P
Pietro
Hi all,
Can we link an mde access database front end to to SQL ?
Can we link an mde access database front end to to SQL ?
To cite someone: Yes, we can!Can we link an mde access database front end to to SQL ?
John Spencer said:Yes, you can. It is easiest to set up the linking BEFORE you convert to an
mde, but it can be done with an mde and vba code that you call.
If you mean you want to relink to a different SQL backend, that is possible
but you will need some VBA code to do the relinking.
One method that works well and does not require setting up a DSN is described
by Doug Steele
Take a look at
http://www.accessmvp.com/djsteele/DSNLessLinks.html
Also Check Carl Prothman's site
http://www.carlprothman.net/Default.aspx?tabid=90#ODBCDriverForSQLServer
for the appropriate connection string to use.
Also check
http://www.connectionstrings.com/
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
Pietro said:Thank you Tom for your reply.
My case exactly is : I'm linking an MDE frontend to an MDE backend.I've
already lost the MDB file, can i upsize the backend and make it SQL
database
and link the MDE frontend to it ?
That's all.
Ok, if could get an mdb backend, can i upsize it with SQL and link it to
my mde frontend?
Pietro said:Ok, if could get an mdb backend, can i upsize it with SQL and link it to
my
mde frontend?
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.