I have experienced this a few times when developing databases on a network.
This is caused by a fleeting lost of connection.
To overcome this I created a blank database then imported tables from the
faulty database then did queries etc During the import you may receive a
message saying object corrupt or something similar. I suggest you import a
small number each time, that way you will have a better idea where the
corrupt object is.
Now I develop my database on a "stand-alone" or laptop or if I use the
network for developing I save a copy of the current database then rename the
current database. I may start out with databasename_001.mdb then save it
usually in a ZIP or 7zip format after I have tested the latest changes then
rename the database as databasename_002.mdb so that if I have problems I
know the previous version is OK
HTH
--
Allan Murphy
Email:
(E-Mail Removed)
"Frustrated" <(E-Mail Removed)> wrote in message
news:A718FED1-1729-4617-A2D9-(E-Mail Removed)...
> I was receiving the error message "Error accessing file, network
Connection
> may be lost", so per the groups responses to other users I had service
pack 3
> installed on my PC and then rebuilt the Dbase from scratch.
> Now, the Dbase is doing strange things.
> 1.) It will not let me create a switchboard, or should I say it will not
> allow me to create a switchboard that actually opens forms.
> 2.)If I copy a form and try to paste it as a new form with a new name I
> receive the message that a form with that name already exists....when it
does
> not. Not only does it not exist a form with the new name has never
existed.
> 3.)When I try to import a form from another Dbase I go through all the
steps
> and it appears the import went smoothly however the objects do not import.
>
> There are other peculiarities going on, but I can't think of them right
now.
>
> Also you should know that yesterday I had IT re-install windows and office
> with the hopes that it was my PC but I am still having the same problems.
I
> am on Windows 2000 and Office 2000. My PC is connected to a network, but
the
> Dbase is sitting on my local drive.
>
> Any idea what might be causing this or how I fix it?