473,397 Members | 2,033 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,397 software developers and data experts.

Locking and Transferdatabase

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
2 1918
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Jer | last post by:
I am trying to export the results of a view from an .adp to an .mdb using TransferDatabase. The code I am using is DoCmd.TransferDatabase acExport, "Microsoft Access", _...
0
by: KJones | last post by:
Here is the setup There are three Machines all running Access97 & XP Pro \\readingtill1 \\redingback \\redingtill2 on a LAN And four dbs
6
by: dixie | last post by:
I am using the Docmd.TransferDatabase to transfer part of a table into another smaller database. The source comes from a select query that transfers the part of the table that I need. The...
1
by: Jens Hofmeier | last post by:
Hello, i want to transfer a table from database sourceMDB to a password protected database named destMDB. I was not able to figure out where to specify the required password ind the parameters...
2
by: AccessStarters | last post by:
I am trying to Import a simple dbase file into my Ak2 TABLES. If I do this manually, it works fine. I get a new table called DBASE with all the data looking good. If I try and do this using VBA...
6
by: Dave Gehrig | last post by:
Hi guys, Using Access 2003 on XP. First time caller, long time listener. I am not a programmer per se, and all my training in coding in the past year or so has come from the wealth of info...
1
by: Danny J. Lesandrini | last post by:
Does anyone know if it's possible to use TransferDatabase to export data to MySQL? If not, how would one go about it? Below is the code I tried to use, but it doesn't work. sTable = "tblLead"...
1
by: solar | last post by:
In copying tables i use the command Transferdatabase shown below.It is a good command, but i need the following refinement. I want to copy the table only when the Yes/No field "accepted" in the...
0
by: rdemyan | last post by:
I'm trying to use TransferDatabase to transfer tables from an external secured DB to a database created in the code. I would like to kind of use automation, although OpenCurrentDatabase apparantly...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.