Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Conversion / February 2005

Tip: Looking for answers? Try searching our database.

Question about converting 97db to 2003 db

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Liz Hansen - 07 Feb 2005 16:42 GMT
Hello,

I have several 97 db that I need to convert to 2003.  I have done most of
them already without any problems except for one.  When I try to convert
this db I get the following msg:

The current user account doesn't have permissions to convert or enable this
database. Then it says things like; You have to join the work group, Your
user account must have open/read access and so on. (I can give you the whole
error msg. if needed).

I didn't design the original 97 db, but as far as I understand there is no
security on it.  We don't have to enter a user name or password when opening
the db in 97, and it works on any workstation that has Access 97.

I have tried joining the work group following the Help file, but that didn't
work.

Any other suggestions how to go about this?  Can I for instance remove the
security that may be on the 97 db since I have full access working with the
db in 97?

Note: I have both Access 97 and 2003 installed on the same machine.  Could
this be causing a problem (so far every other db has worked fine)

Thanks!

Liz
Joan Wild - 07 Feb 2005 19:02 GMT
> I didn't design the original 97 db, but as far as I understand there
> is no security on it.  We don't have to enter a user name or password
> when opening the db in 97, and it works on any workstation that has
> Access 97.

Well it sounds as though it is secure.  You say you don't have to enter a
username/password, but are you starting it via a desktop shortcut?  If so,
have a look at the shortcut to see if it specifies a workgroup file
(/wrkgrp), and includes the username and password switches.

> Any other suggestions how to go about this?  Can I for instance
> remove the security that may be on the 97 db since I have full access
> working with the db in 97?

You can try.  Open Access 97 and create a new mdb, and try importing all
objects from your mdb.

Signature

Joan Wild
Microsoft Access MVP

Liz Hansen - 07 Feb 2005 19:10 GMT
I will try that.  Thanks!

Liz

> > I didn't design the original 97 db, but as far as I understand there
> > is no security on it.  We don't have to enter a user name or password
[quoted text clipped - 12 lines]
> You can try.  Open Access 97 and create a new mdb, and try importing all
> objects from your mdb.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.