G
Guest
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
documentation)?
Any assistance is appreciated.
Thank you.... John
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
documentation)?
Any assistance is appreciated.
Thank you.... John