Network Access was interrupted.

[EddiRae]

Hello,
I have created an Access 2007 application on my computer for a client of mine. I have split the database so that the data is in a separate database. I emailed both databases to the end user and suggested how to place the databases. He is working from home at the moment, so he is not placing these on the network. They are going on his laptop.

He has created a folder in his "My Documents" folder and called it DATABASE. He then has created a folder under that and called it DATA. He placed the DATA database into the DATA folder and has the front-end database in the DATABASE folder. It is like this.

c:\...My Documents\DATABASE\DATA\abc_data.accdb
c:\...My Documents\DATABASE\abc.accdb


He is trying to link the tables that are in the abc_data.accdb to the abc.accdb. There are 13 tables. After the 1st 4 tables are linked, he is getting this error:

Your network access was interrupted. To continue, close the database, and then open it again.

He has tried to relink these tables separately and the rest of them are getting this error.

I am not sure what to look for.

Thanks for your help in advance!!
Eddi Rae

 

[HiTechCoach]

First, make sure to add the folders to the trusted locations.

Second, are you sure that the table that causes the problem in the front end when trying to relinked, actually does exist in the back end?

 

[EddiRae]

Adding the folders to the trusted locations did not work.

Yes. All the tables that are in the link on the front end are in the data database.

I pulled the two databases back together and I am letting the end user split the databases. I never had this issue with Access 2003. This is happening in Access 2007.

 

[DCrake]

If you move the back end to your local drive and try to link to it accross the same drive does it error?

If it does then I would suggest you have a problem with your back end.

Create a new back end with the same table structure but with no records in the tables. Perform the link routine, if ok, run a series of append queries to populate the back end.

 

[EddiRae]

On my PC, I had no problems moving from one drive to another. Of course, I do not have company directories.

The end-user did get back to me after doing the split and it did work!!