Re: Upsizing .mdb for split DB
From: Daran Johnson (daranj_at_hotmail.com)
Date: 03/25/04
- Next message: Daran Johnson: "Re: Access asks for Paramter when Criteria contains @"
- Previous message: Mike Miller: "Count & Sum calculated on recordset results, not filtered."
- In reply to: Joel Wiseheart: "Upsizing .mdb for split DB"
- Next in thread: Joel Wiseheart: "Re: Upsizing .mdb for split DB"
- Reply: Joel Wiseheart: "Re: Upsizing .mdb for split DB"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 25 Mar 2004 12:15:36 -0800
Joel,
The upsize procedure would only apply to the Access database that contains
the data (tables). The forms, reports, VBA etc. would remain in Access as
an ADP. Also, code that references data will have to be re-written. I
would also suggest that you take advantage of Stored Procedures. Books On
Line (BOL) is the best resource. You can find it at Microsoft's website.
There are a number of good books on the topic. I would suggest that you
begin to see this as an Access (ADP) front-end and a SQL Server back-end. I
think that will make the transition easier because some of the issues that I
have read in this newsgroup have more to do with continuing to see the new
system the same way as the old - as one product (i.e. MSDE is a part of
Access like JET is a part of Access).
Remember that you are moving to a true client/server system. The queries
and tables will now be on the server and that is where the work will be done
and the results will be sent to the client where that forms, reports,
macros, and VBA will be. I like to think of the ADP development environment
as a window to the tables, views, stored procedures, and functions residing
on the server. The forms, reports, macros, and VBA are local and in the
file you are working on. When you cannot connect to the server you will
still see the forms, reports, macros, and VBA but not the tables, views,
stored procedures, and functions.
I hope that helps.
-Daran
"Joel Wiseheart" <anonymous@discussions.microsoft.com> wrote in message
news:1365501c4128e$fe1e4870$a401280a@phx.gbl...
> Hello,
> I have found reference materials that discuss how to
> use the "Upsizing Wizard" to upsize from an .mdb file to
> a SQL/MSDE file. Th eproblem is that all the reference
> materials that I have found assume that you're upsizing a
> single, self-contained .mdb file.
> Is there any guides to upsize a from a Jet DB to a
> SQL/MSDE DB & .adp file, that has already been split, so
> the tables are in one .mdb file and the queries (and
> forms, reports, VBA etc.) are in another?
>
> Thanks!
- Next message: Daran Johnson: "Re: Access asks for Paramter when Criteria contains @"
- Previous message: Mike Miller: "Count & Sum calculated on recordset results, not filtered."
- In reply to: Joel Wiseheart: "Upsizing .mdb for split DB"
- Next in thread: Joel Wiseheart: "Re: Upsizing .mdb for split DB"
- Reply: Joel Wiseheart: "Re: Upsizing .mdb for split DB"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
