connect access mde file to sql server

S

SS

Hi All

I have an application build on MsAccess XP with both Front End MsAccess and
Back End MDB file. it seems that the application works perfect on a single
user computer and in a multi-user up to 10 users.I need to convert the Back
End MDB to SQL Database . Is it easy to do without the need to change the
code in the Front End. Or is there a Step By Step Manual to do that ?

thanks in advance

Wael
 
M

Maurice

If it's only your backend you can choose to export your table to SQL-Server.
When done you have a solution which uses 'linked tables'. The front_end will
remain the same. Remeber though that when linking to SQL you need to create a
DSN-source so Access knows what to connect to. When done you can then think
about using DSN-less connections...

hth
 

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

Access 2007 with a 2003 mde and Error 3734 2
Access 2007 and MDE 1
mde to mdb file 2
Access 2007 and MDE Files 1
Using Access Database while Internet Users use DB simultaneously 11
mde access database front end to to SQL 12
CANNOT MAKE MDE FILE 3
Build Client/Server with using Microsoft Access 2003 3

Top