Excel data entry to Access problem

[VE]

Excel 2003 w SP3 Front end
Access 2003 w SP3 database

This is a very old data entry screen. I had to move the Access database where the data is stored. Basically the Excel file looks at a header table in the access database and allows the user to add or change records in a child table in that same access database. After the changes or additions are made the user can see them on the spreadsheet.

I thought that all I needed to do was search the VB for the database name and change the path, but there seems to be another problem.

It adds records to a table, but the new records are no longer visible in the excel data entry file. This worked correctly for several years, but stopped working as soon as I moved the database and changed the path in the VBA.

Any ideas what else I should be looking for? VBA is not something I work in much so "obvious" suggestions are welcome.

Thank you
VE

 

[VE]

OK, I found it. There were places in the code where the path was referenced but it did not specify the .mdb file. I had just searched for .mdb and changed those paths. I should have searched for \\servername and that would have found them all.

 

[SkipVought]

Exactly HOW is Excel Updating the Access database?

Skip,

_{Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference!}

 

[VE]

it's working again now.

I did not write it and the person who did is long gone. It appears to be a SQL insert statement that adds the records to the child table.

 

[SkipVought]

ADO, DAO, linked?

Skip,

_{Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference!}