Hi Catherine,
The VBE editor is likely not open in this case. You used the correct steps.
I'm guessing that you have a more serious problem with wizards not working.
For example, try using the combo box wizard as outlined in this article:
http://www.access.qbuilt.com/html/find_a_record.html
Do you get the first screen of this wizard displayed okay? Try the steps
outlined in this KB article to fix wizard related problems:
http://support.microsoft.com/?id=303769
For step #5, please note that it is important to include a set of quotes
around the full path to the DAO360.dll file. For example, on my PC the
following path is valid, however, this command will fail:
regsvr32 C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll
with a LoadLibrary error. You need to include the quotes, like this, for
this command to be successful:
regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll"
Use the path that is valid for your PC. An easy way to do this is to try
searching for each .dll file that you need to re-register. When the search is
complete, reduce the size of the find files dialog enough so that you can
display both the search results and the Start > Run dialog on the same
screen. Enter the command: Regsvr32 into the Start > Run dialog. Then use
the drag-and-drop technique to drag the dao360.dll file to the Start > Run
dialog. When you drop it in place, the complete path including the
double-quote marks should be filled in automatically.
Manually splitting a database is really quite easy. Just take a copy of your
database and give it a try.
I am just headed out the door now, to go to work, so if you reply I won't be
available for about the next 10 hours or so. Oh, and thank you very much for
marking my first response as an answer! This is much appreciated.
Good Luck, and please let me know how it goes.
Tom
_______________________________________
:
Yes I get this same error with each database I try to split. I have even
tried a very small database with only a few queries. No success. I do not
think I have VBE open. I am new the Access so I may not realize it is open.
The steps I followed to split my database is thru tools and DB splitter.
Thanks for your help. I am not confident enough to split the database
manually.
_______________________________________
:
Hi Catherine,
Did you have the VBE (Visual Basic Editor) open when you attempted to split
the database? Here is one possible cause:
ACC2000: Resetting Code in Visual Basic Editor Causes Problems with Wizards
http://support.microsoft.com/?id=223229
If not, are you receiving the same error messages when you attempt to split
any database? First suggestion is to try re-booting your system to see if the
problem clears up. You can split a database manually--some people prefer this
method--by making a copy of your database. Delete all queries, forms,
reports, macros, modules, etc. from this copy, hereinafter referred to as the
back-end (BE). Also delete any tables from this BE if you want a table to
remain a local table in the front-end (FE).
Then open the FE and delete all tables (except any that you want to remain
local). You should receive messages indicating that relationships must be
deleted (assuming you created relationships which, hopefully, you did). Then
simply use the File > Get External Data... > Linked Tables option to
establish links to the tables in your new BE database.
Tom
_______________________________________
:
using Access 2000 - I am attempting to split a database. I got a message
that reads "subscript out of range" and then another message that reads
"invalid procedure call or argument". Can anyone tell me how to solve this?
Thanks.
