mdb v. adp inquiry



Hello. I am familiar with the mdb and the splitting of the database for
multi users. What is being looked at now is to use sql 2005 express as the
backend and access 2003 as the front end. I have a few questions regarding
this as I have never gone beyond doing access and then splitting it.
Is is possible to keep the file as a mdb and link sql express? If so, how
is that done (or point me to documentation explaining it)? Does it need to
be an adp? How would the connection string be written (or point me to
Any assistance is appreciated.
Thank you.... John

Arvin Meyer [MVP]

You can use an MDB to connect to SQL-Server (any version). You can also use
ADO or DAO. Microsoft's latest defaults for Access 2007 suggest using an
MDB. As for connection strings, a typical connection string for ADO might

Dim strConnect As String

strConnect = "Provider=SQLOLEDB;Data Source=ServerName;" & _
"Initial Catalog=DatabaseName;" & _
"User ID=UserName;password=Password"

Or you can simply create an ODBC connection and link the tables. Create the
ODBC connection by going to the control panel ... administrative tools and
following the steps in the ODBC applet.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

mdb to adp 9
ADP or MDB 5
schema to text file 7
mdb to adp subform problem 3
How to convert mdb -> adp ? 6
Alternative to GoToRecord acNewRec for Access ADP 3
adp vs mdb 9
ADP with SQL 2008 Express 1