How do I access a local table using VB in a split database

G

Guest

Having writen a SELECT to TABLE query I need to access that table using VB
but <Database>.OpenRecordSet(Table) looks for a Table in the remote database
rather than on the local machine. Presumably I need a Local database object?
Having difficulty... Please Help
 
A

Andi Mayer

Having writen a SELECT to TABLE query I need to access that table using VB
but <Database>.OpenRecordSet(Table) looks for a Table in the remote database
rather than on the local machine. Presumably I need a Local database object?
Having difficulty... Please Help
Click to expand...

currentdb ????

do you use codedb???
 

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

Change a linked table to a local table (External) 8
Am I disturbing a machine in production floor if I access its database remotely? 4
VB Code to copy linked table to local 4
Acces 2007 performance 1
Update syntax for a remote table access 1
Query using VBA with local and remote tables 2
Copy Linked Table to Local Table 3
Copy table from open database to a closed database 6

Top