Comments on Alex & Access: How to export objects to secured database

Hi,open secured DB as above and then run:dbsData.E...

2007-12-24T13:05:00.000+03:00

Hi,
open secured DB as above and then run:

dbsData.Execute "Delete * From MyTable Where ID=xxx"

Hi AlexThank you for your help.I want to insert so...

2007-12-24T09:57:00.000+03:00

Hi Alex
Thank you for your help.
I want to insert some records in to a table in a secured database, and before to do that, i want to delete and empty the table first.
best regards:
jack martin

I had the same problem where transferdatabase did ...

2007-08-02T00:22:00.000+04:00

I had the same problem where transferdatabase did not work for the "CurrentProject" (forms, reports etc.) but worked for "CurrentData" (tables, queries etc.)

If this happens between two MS Access databases, try the same export/import from the MS Access application (File->Get External Data->Import), it might give you some insight as to why the code is not working.

In my case, the source database was protected with a password and once I removed it (in the VBA window, Tools -> (project) Properties -> Protection tab) the transferdatabse code worked for forms, reports etc.

when I try to do this I get 2501 transferdatabase ...

2007-03-15T03:24:00.000+03:00

when I try to do this I get 2501 transferdatabase action was cancelled???

Hi, same code should work also

2006-07-18T00:52:00.000+04:00

Hi, same code should work also

what if both of the db's are password protected

2006-07-17T22:48:00.000+04:00

what if both of the db's are password protected