How to change modules to point from access database to sql database

[smartlife]

Hi,

I have a access application which saves and retrieves data from access mdb file,need to change this to point to sql database.

Help is really appreciated.

Thanks
Nani

 

[dhookom]

Have you simply linked to the SQL tables rather than the Access tables?

Duane
Hook'D on Access
MS Access MVP

 

[smartlife]

I have linked all the tables to in mde file to sql,but when I open the application.it is still looking for access mdb file.

Do i need to do anything after linking access tables to sql?


Please let me know if you need more details,I can attach some screen shots.

 

[dhookom]

Can you tell us what you mean by "it is still looking for access mdb file"?

Are the names of the linked SQL tables the same as the names that had been from the mdb file?

Did you unlink the mdb tables?

Is there any code that looks for the linked tables?

Duane
Hook'D on Access
MS Access MVP