connect access mde file to sql server

  • Thread starter Thread starter SS
  • Start date Start date
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
 
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
 
Back
Top