Looking for Suggestions on Scalability Planning

[Don]

We are in the early stages of development for a small Access application.
Until we get some infrastructure issues worked out, the plan is to use
database files (.mdb) on the users machines in a front-end/back-end
configuration. Once we get a database server, the plan is to ditch the local
back-end data files and connect to the database server (probably a MS
SQLServer, but maybe an Oracle server). So, we had a couple of questions:

1) What is the preferred connection method (i.e. ADO, DAO, etc) when
planning for a transition from local mdb files to a database server?

2) Any suggestions on architecture?

3) Any good FAQs, books , or web references, etc on the subject?

Thanks!

Don

 

[Rick Brandt]

We are in the early stages of development for a small Access application.
Until we get some infrastructure issues worked out, the plan is to use
database files (.mdb) on the users machines in a front-end/back-end
configuration. Once we get a database server, the plan is to ditch the local
back-end data files and connect to the database server (probably a MS
SQLServer, but maybe an Oracle server). So, we had a couple of questions:

1) What is the preferred connection method (i.e. ADO, DAO, etc) when
planning for a transition from local mdb files to a database server?

2) Any suggestions on architecture?

3) Any good FAQs, books , or web references, etc on the subject?

Since the recent versions of Access include a free copy of MSDE which is the
same as SQL Server then I would suggest you use that. Later when you move to
full-blown SQL Server you won't have to change anything.