ERROR! Error accessing network file? HELP ANYONE!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am getting a strange error, and cant figure out why. My application is a
simple db, one file with FE & BE in same file for now. I began to get this
error when I imported a couple of reports into the db. I tried to delete the
reports, it confirmed deletion, but when I reopen the file, the code is still
there. I tried compact & repair, I tried compile with no change at all.

Can anyone tell me what I did wrong here, or what I am missing?

Mike Robinson
 
Hi Mike,

You usually get that when your BE can't be found on the network... You
might be heading towards a corruption. Try creating a new blank MDB and
importing all of your tables, queries, forms, reports and modules...
Remember to import your data and relationships also.

Damian.
 
My file is one file right now, it is not split. I did try to create a blank
db. That worked fine, except if I import the same questionable reports, I get
the same error. Somewhere in these reports if the problem I think.
 
Mike

I experienced the same problem. There were problems importing reports or
forms etc. It is due a LAN connection being interrupted during the import.

I suggest, if possible you do your development and changes on a stand-alone
or laptop with no connection to your LAN. Then do your final testing etc on
the LAN
 
I do transfer my files and work at home also. I believe that has something to
do with it, I just dont know what I did, so as not to do it again. Strange.
 
It is most likely to happen when you try to import on the network and your
database is a large >10Mb. I usually do some changes etc, test the changes
then make a copy, make some changes test and make a copy. When I receive a
Network error I only have to go back a couple of copies and redo the
changes.

I also tried the following and found it to work. The problem is mainly in
your forms, reports or modules.

Create a blank database.

1 .Import your tables, then your queries.

2. Import some of your forms, a message will be displayed stating that there
was a problem importing the form when the faulty form is being imported. If
all is OK continue with the remainder of your forms.

3. Do the same with your reports, macroes and modules.

I now do all my developement using a laptop and my PC at home
 
Fred,
Sorry, I did get the help page to come up, this looks like it may help. I am
going to try it right now.

Mike
 
Fred,
That did it. I installed SP3, then copied, imported etc...with no problem.
Thanks to you and all for replying so fast.

Mike robinson
 
Glad to help!

Fred

Mike Robinson said:
Fred,
That did it. I installed SP3, then copied, imported etc...with no problem.
Thanks to you and all for replying so fast.

Mike robinson
Click to expand...
 
MDB is too flaky for real-world use.

Move to SQL Server and you won't be playing Russian Roulette with your
data
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

error 282 at 2013 migration with access 0
Compile error after DB Split in queries 8
Can't open Access 2000 formatted DB 1
Error 1517 9
Anyone Else Facing Public Folder Migration Errors in Exchange? 0
Access XP file Error 4
Compile Error : Type Mismatch 2
Log File of Compact: what does it mean? 1

Back
Top