Database Splitting Error

[Guest]

I have a database that is being used by multiple users. There have been
complaints that they are being locked out/frozen when entering information. I
decided to split the database, but I am running into errors every time. To
split it, I am using a copied version of the database that I am running
exclusively on my own private drive.

They are different each time. Most recently, the error has been that one
table is being used by a person or process.

This results in Access being completely frozen (requiring me to use task
manager to end the program).

What is wrong???

 

[Guest]

Hi Jodstar,

I decided to split the database, but I am running into errors every time.

Are you running into errors every time while attempting to split the
database, or are these errors occuring when testing the result of splitting?

They are different each time. Most recently, the error has been that one
table is being used by a person or process.

It is helpful if you can quote error numbers, along with the exact text of
the error message(s). Also, what process were you doing when the error was
encountered? For example, "running a VBA procedure initiated by a command
button", in which case you will want to copy the procedure and paste it into
a reply.

This results in Access being completely frozen (requiring me to use task
manager to end the program).

One possible cause is VBA code that is in an endless loop. This can be
caused by forgetting to include a .movenext statement. However, this type of
error would not be specific to a split versus unsplit application.

Are all PC's fully updated with the latest service packs for 1.) the
operating system, 2.) the version of Office that you are running and 3.) the
JET database engine? Use this KB article as a guide:

How to keep a Jet 4.0 database in top working condition
http://support.microsoft.com/?id=303528


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Guest]

:
To answer the questions from your previous response:
1. I have been receiving the errors each time I try to split- I click to use
the Database Splitter, save the be file, and part way through splitting, it
displays these messages:

i) The database engine could not lock table 'Intracompany Work Requisition'
because it is already in use by another person or process.

ii) Invalid procedure or call argument

There are no error numbers. Only this text.
After clicking ok, the program is completely frozen.

I am not sure if the PCs are fully updated with the latest service packs,
but this error is only for this one database (I work at a crown corporation
and will not have the authority to download these service packs). I have
successfully split other databases without this problem .

Some other information that might help- i have tried to manually split the
databases by importing the tables into another database. When I do this, it
begins importing and then freezes part way through (just never completes).

I wish I could be more concise but this is all I know about the error...
ideas?

 

[Fifth Amendment]

database splitting is no longer reccomended

it is reccomended that you use Access Data Projects for new multi-user
Access applications

 

[Guest]

Hi Jodstar,

With Access closed, use Windows Explorer to navigate to the folder that
contains the database you are attempting to split. You should not see a
corresponding locking database file (a file with the same root name, but with
the .ldb file extension). This file is typically 1 KB in size. If you see it,
try deleting it.

Notes:
1.) You may need to configure Windows Explorer to see file extensions for
registered file types.
2.) You will not be able to delete it if someone else has the file open.
3.) If no one else has the file open, and there is a .ldb file present, this
can indicate some corruption. More information here:

Introduction to .ldb Files
http://support.microsoft.com/?id=299373

ii) Invalid procedure or call argument

This is run-time error 5. A couple of possibilities for this error include
the following:

Resetting Code in Visual Basic Editor Causes Problems with Wizards
http://support.microsoft.com/kb/223229

Error Messages That Indicate a Missing Reference
http://support.microsoft.com/kb/231413

You might try temporarily disabling your antivirus software. There have been
some reported instances where default AV software settings prevent Wizards in
Access from running properly.

As for the service packs, you can use the information in the article I
provided to verify whether or not the latest service packs are installed. If
not, you can attempt to get this situation remedied by contacting the
appropriate group within your company.

Some other information that might help- i have tried to manually split the
databases by importing the tables into another database. When I do this, it
begins importing and then freezes part way through (just never completes).

Now that's interesting. Is there any sign of corruption when you are using
the unsplit application? Can you create an empty .mdb file and then export
your tables from the unsplit application to the new empty .mdb file?

You have rebooted recently, right?

Try re-registering your wizard file, DAO and ADO, just for good measure. You
can likely do this without admin. rights. Click on Start > Run. Then enter
the following commands, pressing the <Enter> key after each one:

Regsvr32 Accwiz.dll
Regsvr32 "C:\Program Files\Common Files\system\ado\Msado15.dll"
Regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\Dao360.dll"

You should get a message indicating success in each case.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[aaron.kempf]

and, btw-- why use ADO 1.5?
Windows XP Comes with 2.6 right? And Windows 2000 comes with 2.5?