Database Splitter problem.

[Anttonio]

I just tried to use the Database Splitter Wizard to split
an access Database. The the starts to split, but about 20
seconds into it, everything stops, and the following
error message pops up.
"Database Splitter - Subscript Out of Range"
When I click on "OK" another error message pops up that
says:
"Database Splitter - Invalid Procedure Call or Argument"
Then the database splitter window pops up where I started
from..and thats it.
A back end copy is created in the folder I specified when
I started the splitter, but this only contains the tables
and nothing else...
I appreciate any help.
tx

 

[Arvin Meyer]

I have never seen the need to use the splitter since it is so easy to do it
without it. Make 2 copies of the database. Name one FE.mdb (front-end) and
the other Data.mdb. In Data.mdb, delete everything but the tables and
compact it 2 or 3 times. In FE.mdb, delete only the tables and compact it 2
or 3 times. Now choose Tools ... External data from the FE.mdb and link all
the tables in Data.mdb.

You're done!
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Tom Wickerath]

Hi Anttonio,

While Arvin solution is very easy, I wonder if the symptom is not indicative of another problem.
Can you split other databases using the wizard, or do you encounter the same problem? Try it on
a copy of the Northwind sample database.

One cause of an "Invalid Procedure Call or Argument" error message is a missing reference. I'm
not sure if a missing reference in a database would affect the ability of a wizard to run
properly, but it's certainly easy enough to check out.

ACC2000: Error Messages That Indicate a Missing Reference
http://support.microsoft.com/?id=231413

ACC2000: How to Resolve Reference Issues in an Access Database
http://support.microsoft.com/?id=310803

Note: The above KB articles apply to Access 97, 2002 and 2003 as well, although this is not
apparent by reading the titles. Several of the wizards require a properly registered DAO360.dll
(Access 2000 and above) or DAO350.dll (Access 97) library. If your copy is not registered
properly, this might be the cause of the error. Follow the instructions in
http://support.microsoft.com/?id=319841 to re-register DAO.


Tom
_____________________________________


I have never seen the need to use the splitter since it is so easy to do it
without it. Make 2 copies of the database. Name one FE.mdb (front-end) and
the other Data.mdb. In Data.mdb, delete everything but the tables and
compact it 2 or 3 times. In FE.mdb, delete only the tables and compact it 2
or 3 times. Now choose Tools ... External data from the FE.mdb and link all
the tables in Data.mdb.

You're done!
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

_____________________________________


I just tried to use the Database Splitter Wizard to split an access Database. The starts to
split, but about 20 seconds into it, everything stops, and the following error message pops up.

"Database Splitter - Subscript Out of Range"

When I click on "OK" another error message pops up that says:

"Database Splitter - Invalid Procedure Call or Argument"

Then the database splitter window pops up where I started from..and thats it. A back end copy is
created in the folder I specified when I started the splitter, but this only contains the tables
and nothing else...
I appreciate any help.
tx

 

[Guest]

Thank you so much for the response.
Ok. If I have user level security running (I set this up
through the Security Wizard), do I first have to disable
it? Delete it? I tried to open a blank database and
import tables and queries etc, but I got an error message
saying I didn't have the necessary permissions to do
this....so, will all the security settings/file have to
be deleted before I can split the database in the manner
you suggested?

 

[Antonio]

Tom,
Thank you so very much for responding. I went to the
pages you suggested and looked at the references. I could
find no "missing" references. (the four that are checked
off by default were there at the top of the list with
check marks) Could it be possible that the mdw file User
Level Security set up and the specific security settings
are keeping me from splitting the database?

-----Original Message-----
Hi Anttonio,

While Arvin solution is very easy, I wonder if the

symptom is not indicative of another problem.

Can you split other databases using the wizard, or do

you encounter the same problem? Try it on

a copy of the Northwind sample database.

One cause of an "Invalid Procedure Call or Argument"

error message is a missing reference. I'm

not sure if a missing reference in a database would

affect the ability of a wizard to run

properly, but it's certainly easy enough to check out.

ACC2000: Error Messages That Indicate a Missing Reference
http://support.microsoft.com/?id=231413

ACC2000: How to Resolve Reference Issues in an Access Database
http://support.microsoft.com/?id=310803

Note: The above KB articles apply to Access 97, 2002 and

2003 as well, although this is not

apparent by reading the titles. Several of the wizards

require a properly registered DAO360.dll

(Access 2000 and above) or DAO350.dll (Access 97)

library. If your copy is not registered

properly, this might be the cause of the error. Follow the instructions in
http://support.microsoft.com/?id=319841 to re-register DAO.


Tom
_____________________________________


I have never seen the need to use the splitter since it is so easy to do it
without it. Make 2 copies of the database. Name one FE.mdb (front-end) and
the other Data.mdb. In Data.mdb, delete everything but the tables and
compact it 2 or 3 times. In FE.mdb, delete only the tables and compact it 2
or 3 times. Now choose Tools ... External data from the FE.mdb and link all
the tables in Data.mdb.

You're done!
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

_____________________________________


I just tried to use the Database Splitter Wizard to

split an access Database. The starts to

split, but about 20 seconds into it, everything stops,

and the following error message pops up.

"Database Splitter - Subscript Out of Range"

When I click on "OK" another error message pops up that says:

"Database Splitter - Invalid Procedure Call or Argument"

Then the database splitter window pops up where I

started from..and thats it. A back end copy is

created in the folder I specified when I started the

splitter, but this only contains the tables

 

[Arvin Meyer]

Yes, security sometimes gets in the way. You'll need to make sure that you
have proper permissions. It is usually advisable to build the database with
security in mind as permissions problems are often easier to work with on a
per object basis. You can set permissions globally though (provided you are
the owner or admin). You might find it easier to de-secure the database,
split it, then re-secure it. Make sure you have a good backup copy of
everything. You'll also find the security faq helpful.

http://support.microsoft.com/support/access/content/secfaq.asp

The problem may also be as simple as needing to connect to the correct
system.mdw to get the permissions you need. The syntax from a shortcut looks
like:

"C:\Program Files\Office10\MSACCESS.EXE" "C:\Projects\App.mdb" /wrkgrp
"C:\Projects\Secured.mdw"

all on 1 line.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Tom Wickerath]

Hi Antonio,

Could it be possible that the mdw file User
Level Security set up and the specific security settings
are keeping me from splitting the database?

I'm not the right person to answer Access security issues, other than to point people to the
Security FAQ, as Arvin already has in his post this morning. If you can successfully split
non-secured databases, such as an original copy of the Northwind sample database, then one can
probably conclude with confidence that the issue was related to security permissions. Like Arvin
suggested, try removing security and then see if the splitter wizard works okay.

Tom
_________________________________________


Tom,
Thank you so very much for responding. I went to the
pages you suggested and looked at the references. I could
find no "missing" references. (the four that are checked
off by default were there at the top of the list with
check marks) Could it be possible that the mdw file User
Level Security set up and the specific security settings
are keeping me from splitting the database?


_________________________________________

Hi Anttonio,

While Arvin's solution is very easy, I wonder if the

symptom is not indicative of another problem.

Can you split other databases using the wizard, or do

you encounter the same problem? Try it on

a copy of the Northwind sample database.

One cause of an "Invalid Procedure Call or Argument"

error message is a missing reference. I'm

not sure if a missing reference in a database would

affect the ability of a wizard to run

properly, but it's certainly easy enough to check out.

ACC2000: Error Messages That Indicate a Missing Reference
http://support.microsoft.com/?id=231413

ACC2000: How to Resolve Reference Issues in an Access Database
http://support.microsoft.com/?id=310803

Note: The above KB articles apply to Access 97, 2002 and

2003 as well, although this is not

apparent by reading the titles. Several of the wizards

require a properly registered DAO360.dll

(Access 2000 and above) or DAO350.dll (Access 97)

library. If your copy is not registered

properly, this might be the cause of the error. Follow the instructions in
http://support.microsoft.com/?id=319841 to re-register DAO.


Tom
_____________________________________


I have never seen the need to use the splitter since it is so easy to do it
without it. Make 2 copies of the database. Name one FE.mdb (front-end) and
the other Data.mdb. In Data.mdb, delete everything but the tables and
compact it 2 or 3 times. In FE.mdb, delete only the tables and compact it 2
or 3 times. Now choose Tools ... External data from the FE.mdb and link all
the tables in Data.mdb.

You're done!
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

_____________________________________


I just tried to use the Database Splitter Wizard to

split an access Database. The starts to

split, but about 20 seconds into it, everything stops,

and the following error message pops up.

"Database Splitter - Subscript Out of Range"

When I click on "OK" another error message pops up that says:

"Database Splitter - Invalid Procedure Call or Argument"

Then the database splitter window pops up where I

started from..and thats it. A back end copy is

created in the folder I specified when I started the

splitter, but this only contains the tables

 

[Antonio]

thank you very very much.
Antonio

-----Original Message-----
Hi Antonio,


I'm not the right person to answer Access security

issues, other than to point people to the

Security FAQ, as Arvin already has in his post this

morning. If you can successfully split

non-secured databases, such as an original copy of the

Northwind sample database, then one can

probably conclude with confidence that the issue was

related to security permissions. Like Arvin

 

[Antonio]

thank you very very much!
Antonio

-----Original Message-----
Yes, security sometimes gets in the way. You'll need to make sure that you
have proper permissions. It is usually advisable to build the database with
security in mind as permissions problems are often easier to work with on a
per object basis. You can set permissions globally though (provided you are
the owner or admin). You might find it easier to de- secure the database,
split it, then re-secure it. Make sure you have a good backup copy of
everything. You'll also find the security faq helpful.

http://support.microsoft.com/support/access/content/secfa q.asp

The problem may also be as simple as needing to connect to the correct
system.mdw to get the permissions you need. The syntax from a shortcut looks
like:

"C:\Program Files\Office10

\MSACCESS.EXE" "C:\Projects\App.mdb" /wrkgrp

 

[ÀÌÂù³ë]

I have never seen the need to use the splitter since it is so easy to do it
without it. Make 2 copies of the database. Name one FE.mdb (front-end) and
the other Data.mdb. In Data.mdb, delete everything but the tables and
compact it 2 or 3 times. In FE.mdb, delete only the tables and compact it 2
or 3 times. Now choose Tools ... External data from the FE.mdb and link all
the tables in Data.mdb.

You're done!
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access