Re: AC2000 - what's wrong with this code? - the answer

#1

Deano wrote:

Quote:

Here's some code that someone wrote for me. It's supposed to copy
tblRights from an external mdb into my main database. tblRights
already exists there so when it's copied in it becomes tblRights1.

tblRights is cleared out using the DELETE line and then the contents
of tblRights1 is appended into tblRights. Finally tblRights1 is
deleted.

However when i check I find that tblRights is empty; the code hasn't
copied the records over - anyone know why it's not working?
tblRights does have relationships but I'm pretty sure this shouldn't
affect it.

-----that code snippet----
'selectedBU contains the path.

DoCmd.TransferDatabase acLink, "Microsoft access", selectedBU,
acTable, "tblRights", "tblRights"
DoCmd.RunSQL "DELETE tblRights.* FROM tblRights;"
DoCmd.RunSQL "INSERT INTO tblRights SELECT tblRights1.* FROM
tblRights1;" DoCmd.DeleteObject acTable, "tblRights1"

Just in case anyone's interested I worked out what was bugging out my code.
I noticed that the tables WERE importing OK but then when a certain tables
was imported the data in the problem tables suddenly disappeared.
This new table was related to the problem tables and seems to cause some
form of cascading deletion when imported.
Soooo, the solution was to import this table before any of the others - now
works ok!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: AC2000 - what's wrong with this code? - the answer

comp.databases.ms-access comp.databases.ms-access

Re: AC2000 - what's wrong with this code? - the answer - 07-29-2003 , 09:21 AM