By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,498 Members | 835 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,498 IT Pros & Developers. It's quick & easy.

Locking and Transferdatabase

P: n/a
Hi all,
I am trying to use transferdatabase to link tables to a shared backend.
If someone is already using the back end, transferdatabase tries to
lock the table and causes an error. Is there another way to control
locking on transferdatabase since no data is in question? Is there
any other way to link tables other than ADOX?
Thanks
Pachydermitis
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
TC
You can link tables using DAO (and VBA). Check out online help for the DAO
Connect property. You should be able to find some examples, from there.

HTH,
TC
"Pachydermitis" <de******@hotmail.com> wrote in message
news:4f**************************@posting.google.c om...
Hi all,
I am trying to use transferdatabase to link tables to a shared backend.
If someone is already using the back end, transferdatabase tries to
lock the table and causes an error. Is there another way to control
locking on transferdatabase since no data is in question? Is there
any other way to link tables other than ADOX?
Thanks
Pachydermitis

Nov 12 '05 #2

P: n/a
Thanks. I'm trying to avoid DAO as it is causing the problems I'm having.

"TC" <a@b.c.d> wrote in message news:<1074662172.596098@teuthos>...
You can link tables using DAO (and VBA). Check out online help for the DAO
Connect property. You should be able to find some examples, from there.

HTH,
TC
"Pachydermitis" <de******@hotmail.com> wrote in message
news:4f**************************@posting.google.c om...
Hi all,
I am trying to use transferdatabase to link tables to a shared backend.
If someone is already using the back end, transferdatabase tries to
lock the table and causes an error. Is there another way to control
locking on transferdatabase since no data is in question? Is there
any other way to link tables other than ADOX?
Thanks
Pachydermitis

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.