T
Tony
I recently encountered a really awkward error.
I have a multiuser access2k (frontend/backend) database
setup backend - tables, frontend - everything else. It
uses a workgroup file and have the users assigned to
various groups with various permissions.
The problem is when entering a record and wants to save, I
get a "disk or network error" popup. I click "ok" and is
not able to save the record and lose what was typed. Also
when I clicks on tables or queries... it's comes up as
blank... all the tables and queries disappears...
i have to exit and go back into the database to see the
tables and queries again..
has anyone had this problem and if so how did you fix it?
I already tried the following steps.
1) Compacted and Repair both frontend + backend MDB files
2) Made sure user is has the Office 2000 sp3 update
3) I am having problems recompiling the frontend database.
It was suggested to me that the frontend database needs to
be recompile after you import objects into it. There is no
code in any of the forms, no macros, and no modules.
However, as suggested, I wanted to recompile it. I went
into the Visual Basic editor and tried to recompile but I
got the error "Error accessing file. Network connection my
be lost."
I'm fairly certain that the network connection is there...
because I can access other MDB files on the server.
Has anyone encounter this problem before? If so what
resolutions did you try?
Much Thanks and Appreciation, Tony
I have a multiuser access2k (frontend/backend) database
setup backend - tables, frontend - everything else. It
uses a workgroup file and have the users assigned to
various groups with various permissions.
The problem is when entering a record and wants to save, I
get a "disk or network error" popup. I click "ok" and is
not able to save the record and lose what was typed. Also
when I clicks on tables or queries... it's comes up as
blank... all the tables and queries disappears...
i have to exit and go back into the database to see the
tables and queries again..
has anyone had this problem and if so how did you fix it?
I already tried the following steps.
1) Compacted and Repair both frontend + backend MDB files
2) Made sure user is has the Office 2000 sp3 update
3) I am having problems recompiling the frontend database.
It was suggested to me that the frontend database needs to
be recompile after you import objects into it. There is no
code in any of the forms, no macros, and no modules.
However, as suggested, I wanted to recompile it. I went
into the Visual Basic editor and tried to recompile but I
got the error "Error accessing file. Network connection my
be lost."
I'm fairly certain that the network connection is there...
because I can access other MDB files on the server.
Has anyone encounter this problem before? If so what
resolutions did you try?
Much Thanks and Appreciation, Tony