Is this possible in Access 2000??

[brheem]

I currently have an Access 2000 client/server application. The client has all the forms, queries, etc.. and has linked tables to the server database.

I was wondering if it was possible for the client's linked tables to be linked to the server's queries instead of the servers tables.

for instance, if I have a linked table call tblTable1 on the client, is there a way to link this table to a query on the server database called tblTAble1?

Thanks,
Bryan

 

[koresnordic]

Select tools > database utilities > linked table maanger. This will show you all your linked tables. Select them all by clicking in the box to the left of the name and also select the option at the bottom to prompt. Click ok. You will be asked for a new location of this file. Note the new table must be exactly the same format as the old.

Graham

 

[brheem]

Hi Graham,

Thanks for your reply. When you say 'Note the new table must be exactly the same format as the old.' are you saying that I can't re-link a client table to a server Query?

Here is a more detailed explanation to my situation.

I have my server_old.mdb which has a table called tblTable. My client.mdb has a linked table to tblTable. I have a new server_new.mdb which has a query called tblTable which returns all the fields from the tblTable. Can I relink (through the table manager or in VBA code) the client linked table tblTAble to the tblTable QUERY on the server_new.mdb??

When I try to use the linked table manager, and I choose the server_new.mdb, I get an error message saying that Jet can not find the input table or query.

Thanks,
Bryan

 

[annsolomon]

Bryan, you only "link" to tables, not queries. You can "import" queries, but that would defeat the purpose of splitting your database anyway. The queries should reside in the front end database.

By the way, if you linked your front end to tables on the back end, you don't actually have the tables on your front end anyway. They're just "pointers" to the actual tables that reside on the server. Ann