Change database dynamically

  • Thread starter Thread starter Malee
  • Start date Start date
M

Malee

Hi, Could you please guide me what (Ummmm... I'm not sure what should I call
it ... data access model ?, method ? or technics?) suitable to my program.
Major condition to determine is I 'ld like my program to change from one
database to another database ,such as change from .mdb to SQL Server
database, without changing any of my source code. And it should generate
enough good performance. I plan to program in AccessXP.

TIA for any suggestion,
Malee
 
Many of the same design and implementation techiques work both for a split
multiuser database and for an Access client to SQL Server.

In both cases, a primary performance concern is to limit the amount of
information that is passed across the network. Such things as limiting the
number of Records and number of Fields retrieved by the RecordSource of a
Form or Report by using a Query or SQL as the RecordSource rather than using
a Table or a Query without Criteria.

A newsgroup post is not appropriate for a full tutorial and I don't know
many people who could just sit and write one "on the fly", anyway. There are
some excellent performance hints, tips, information, and links (especially
for multiuser environment) at MVP Tony Toews' site,
http://www.granite.ab.ca/accsmstr.htm.

Take a look there and see if that helps.

You can certainly NOT expect to make no changes to an Access UI and have an
_optimized_ front end for both multiuser and client to server, but you
should, with some effort, be able to create an acceptable one. Clearly there
will be some differences... in TableDefs, for example, between the two.
There may also be some other differences that you will need or want.

Larry Linson
Microsoft Access MVP
 
Back
Top