How to Get Copied Database to Work

D

doyle60

I have an Access 2000 database. This database has user-level security
which first needs to be
removed.
I first tried to remove the user-level security by doing the
following:

- give all user groups total access to every object in the database
- clear the admin password
- create a blank database
- Get external data and import all objects from the original database
into it, selecting the options "relationship", "Menus and toolbars"
and
"import/Export Specs"

This newly created database should be free of user-level security.
However the new database does not work properly.

For example, when I try to open the switchboard form, I get a
"compile
error: user-defined type not defined" for "Dim dbs As Database".
Another form gives me the same error for "Dim Q as QueryDef".

How do I clear these errors? Did I not import the objects properly
into
the newly created database? The original database does not present
these errors.

Sandra
 
T

Tom van Stiphout

On Mon, 6 Apr 2009 03:37:58 -0700 (PDT), "(e-mail address removed)"

This is a FAQ. Code window > Tools > References: set a reference to
Microsoft DAO 3.6

-Tom.
Microsoft Access MVP
 
D

doyle60

Thanks. I don't have the database with me now, but how do I get the
"references" to show up on the Tools menu? I believe I didn't see
it. I know how to get it up in another database but if I remember
correctly it wasn't happening with the one in question.

Thanks.
 
J

JimBurke via AccessMonster.com

Not the 'standard' Tools menu, the one you get when you 're in the code
window - I'm assuming you're looking at the 'standard' Access menu bar. Just
do a View, Code from the standard toolbar, then do Tools, References once
you're in the code window.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top