Linked Tables in deployed Access file

[loki1049]

I have access 2007 which I have created a DNS to SQL server hosted somewhere on the internet. I need to create a query in access to modify the data on the server side through linked tables, and send this access file to my client to make the changes. Therefore the linked tables have to remain "linked" when the client uses the query.

I already created the ODBC and named it a specific DNS, and I can see the data fine. I want to somehow keep this link intact when I give the file to the client so that they don't have to create a ODBC connection.

Is there a way to employ this connection embedded into the file? Do I have to use Visual Basic Code somehow?

Any help would be greatly appreciated.

 

[HiTechCoach]

I already created the ODBC and named it a specific DNS, ...

Did you really mean DSN not DNS?

Is there a way to employ this connection embedded into the file? Do I have to use Visual Basic Code somehow?

Any help would be greatly appreciated.

You have two choices:

1) create eh DSN on the the target machine. Either manually or with VBA code.

2) Change the linked table to use a DSN-less Connection.

 

[loki1049]

Yes I meant DSN.

And are you sure that's the only way to do it? I have never used the visual basic editor in access. I read somewhere about just creating a DSN file and linking with that, and then after the first use it should be integral to the access file, no longer requiring the DSN file.

Only reason I am asking, is because out of no where the client says they can't open the linked tables, yet they worked before. The file was created in Access 2000, then modified and saved in access 2007. Could that be why its not working?

 

[HiTechCoach]

Yes I meant DSN.

And are you sure that's the only way to do it? I have never used the visual basic editor in access. I read somewhere about just creating a DSN file and linking with that, and then after the first use it should be integral to the access file, no longer requiring the DSN file.

Only reason I am asking, is because out of no where the client says they can't open the linked tables, yet they worked before. The file was created in Access 2000, then modified and saved in access 2007. Could that be why its not working?

If you have converted to 2007, have you tried deleting the linked tables and recreating the linked tables.

 

[loki1049]

I will have to try that, thanks for the suggestion.