Import & Export error

[db_john]

I'm helping my friend to migrate an Access 97 to newer version but encounter problem in importing or exporting the table. The current system has 2 mdb, one for tables only, one for forms/reports etc. The 2nd mdb has links to the tables in 1st mdb.

To make migrating easier, I copy both tables to my computer and simulate the link path by creating the same folder holding the 2 mdb. If I run the 2nd mdb, I can only all interfaces and edit the data. Then, I want to export the tables from the 1st mdb to the 2nd one and then copy to my own computer to try. I can export all of them except the main customer's data table. The error is same if I only the 2nd mdb and import tables from the 1st.

The error msg is "MS Jet DB engine stopped because you and another user are attempting to change the same data at same time." On click Help button, I got the Error 3197 page. I'm sure that I'm the only one as both mdb are now sitting in my computer w/o any other user to use it. How can I rectify this problem and export the last table to the 2nd mdb? Thanks for your advices.

 

[vbaInet]

Close the db you're importing from completely and run the Import from the other db.

 

[db_john]

Thanks, vbaInet, I'll try that and post back the results.

 

[db_john]

I opened the table mdb, import all queries forms, reports, macro and modules from the program mdb. No problems. The merged mdb has a startup form and is successfully loaded then the menu displays. I ran several options and open the interface displaying the customer data. So far, no problem.

Here comes the final testing part - exporting the customer data table. Same error. As the error related to other user is changing same data in same time, I wrote a new interface to open the customer table in a recordset then run the edit and update methods on all records. But I still cannot export the table.

any further suggestions, thanks?

 

[vbaInet]

I opened the table mdb, import all queries forms, reports, macro and modules from the program mdb. No problems. The merged mdb has a startup form and is successfully loaded then the menu displays. I ran several options and open the interface displaying the customer data. So far, no problem.

Here comes the final testing part - exporting the customer data table. Same error. As the error related to other user is changing same data in same time, I wrote a new interface to open the customer table in a recordset then run the edit and update methods on all records. But I still cannot export the table.

any further suggestions, thanks?

In your interface are you closing the recordset or set it to Nothing? Look through all your recordset code.

set rst = Nothing

You mentioned you had exported ALL objects successfully, but then again in your second paragraph mentioned that you weren't able to export the Customers table. I'm confused by that statement.

 

[db_john]

I search the codes in the form, there is no rst.close or set rst=nothing.
However, if the form is closed and the database is closed, should the rst closed automatically?

 

[vbaInet]

It's always safer to close or set to nothing objects that you created. It should in theory close when you close the module but they have been some problems with memory leakage. So set all of them to Nothing.