Opening Access 97 MDB in Access 2010

I have a very old Access mdb file (Access 97 I think) but I can't open it due to insufficient permissions.

Now my understanding is that I need the original mdw file, which I don't have. What I do have is the original user name and password for admin account access to the database.

I know in earlier version of Access I could use the /user and /pwd switched to enter the admin credentials but how do I get into this database using Access 2010.

I have the discs somewhere for Access 97 but I doubt it will even install on Windows 7 64 bit.

Sponsored Links:

Related Topics

Opening Access 2000 file in Access 2010
I have problem with opening my (10 years) old MDB file in Access 2010. I can open it in MS Access 2003 without any problem, but in Access 2010 I have to enter user name and password before opening. But I haven't ever set it, so I don't know it.

Any idea how to solve it


Change Access 2003 mdb workgroup using Access 2010
I just upgraded to Access 2010 from 2003. With 2003, I was able to open protected mdb files using Workgroup Administrator and joining (changing) the workgroup. This was done BEFORE opening the mdb file.

I can't do this with Access 2010 - there's no option to change a workgroup.

I scoured the internet for an answer. The closest one suggested creating a shortcut and having the target point to the Access application, then the mdb file, then use a "wrkgrp" command to point to the workgroup file (all this in one space-divided string). The answer related to Access 2007, and it doesn't work in 2010 (unless I'm doing something wrong).


Change Access 2003 mdb workgroup using Access 2010
I just upgraded to Access 2010 from 2003. With 2003, I was able to open protected mdb files using Workgroup Administrator and joining (changing) the workgroup. This was done BEFORE opening the mdb file.

I can't do this with Access 2010 - there's no option to change a workgroup.

The closest one suggested creating a shortcut and having the target point to the Access application, then the mdb file, then use a "wrkgrp" command to point to the workgroup file (this in one space-divided string).


.mdb under Access 2010
I have a rather complex database in Access 2003, .mdb format. I understand the conversion to 2010 (similar to 2007) can be tedious.

I further understand that it is possible to run in .mdb format under Access 2010.

I would like to hear expert opinions ( I am most definitely NOT an Access professional), on the advisability of doing that: what features I would not be able to use, or if it is even worth leaving the coccoon of


Compatibility of mdb Format Over Ms Access 2010, Office 2010
While adding any simple command button (having code)on Microsoft form created in MS Access 2003(mdb) and try to save it in MS Access 2010 in same db format (mdb), I am getting the following error

"This form or report contains changes that are incompatible with the current database format. The form or report was not saved."

This way I am not able to add any control on mdb format using MS Access 2010. Could anyone help me out how it can be possible


Opening Report Crashes Access 2003
In a nutshell, whenever I try to open a report in Access 2003, all of Access crashes and offers to send an error summary to Microsoft. The report was created using Access 2010 in .mdb format.

The weird thing is that the query the report is based on IS working just fine, so I think it must be something to do with the report's format.

Are reports created in 2010 usually backwards compatible with 2003 assuming create them in .mdb format?


Encrypting a field
I have an split Access database (mdb) that has just been moved to Access 2010 but kept as an mdb. In the main table there is a field that holds a Social Security Number. The new head of IT is concerned that this field has just been sitting out there on the network (rightly so) and wants to encrypt it. I have no experience with working with it at that level. Can anyone tell me if it is possible in either Access 2003 or Access 2010, mdb or accdb to do this? If so, can you tell me how? The field is not an ID field and only shows up on the form and possibly on a report


Run multiple version of Access
We have access 97 and we are migrating to access 2010 run-time. Is there a way to have access 2010 only take file associations over .accdb and keep .mdb associated with access97 while we convert over? I'm attempting to role access 2010 run time via group policy(Active directory) and script the whole associations thing. But the problem is every time I get the associations right, as soon as you launch access 2010 it re-registers itself for .mdb files. Very Very frustrating


Encrypting a field
I have an split Access database (mdb) that has just been moved to Access 2010 but kept as an mdb. In the main table there is a field that holds a Social Security Number. The new head of IT is concerned that this field has just been sitting out there on the network (rightly so) and wants to encrypt it.

I have no experience with working with it at that level. Can anyone tell meif it is possible in either Access 2003 or Access 2010, mdb or accdb to do this? If so, can you tell me how? The field is not an ID field and only shows up on the form and possibly on areport.


mdb wont open with double click
My new system will not open an MDB file from Windows Explorer when someone else has it open unless I open Access first. If the file is not open, a double-click on the file icon will open it without problems.

If the file is open by another user, my machine apparently does not open it (Access does not show up in Task Manager) but it adds my machine name to the open LDB file!

I have already tried dis-associating MDB with Access, then shutting down, and then re-associating the MDB file types with Access. It did not solve the matter.

The file is in Access 2003: I just got a new system running Windows 7 and Office 2010 today. This same issue came up previously with a co-worker with her Windows XP-Pro machine suddenly stopped opening MDBs that someone else had open unless Access was started first.


Using *.mdb within Access 2007/2010 over the long run.....
I have a 2003 *.mdb that I have user-level security on. I just managed to tweak the password shortcut so that it'll open in Access 2010(2007). I've tested it some and the user-level security seems to be in tact.

My Question: Have any of you had a longer-term experience with using an *.MDB inside the Access 2010/2007? Wondering if there may be some issues down the road I am not thinking of/testing.

We have 13 users who have been read-only users and 2 who have had full data access while working under ver 2003. However, now I.T. is wanting to know if they can push out 2010 on all machines and remove version


.mdb v. .accdb
I've just upgraded from Access 2003 to 2010. At the time I was not aware that the file format had changed from .mdb to .accdb. At first I could not open my .mdb files in Access 2010 but found that if I enabled all macros in Access I could open the .mdb files and save them however, they still save as .mdb files and I continue to only be able to open them with all macros enabled. I understand this is a potential security threat and would like to disable macros but unfortunately can't view my files if I do. Am I missing something, doing something wrong or just out of luck


Access 2010 form opening as read only
I have developed a database in Access 2003 which is used in a networked environment. Recently some users upgraded to 2010, and when opening some forms in this version the add records button is disabled in the navigational toolbar


Access 2000 Database Report freezing until opening other reports
I am running a 2000 Access Database that when I go to open a certain Report (containing sub forms) will cause Access 2010 to stop responding. It will do this with all versions of the Database and on both 2007/2010 Access, and until I start opening other reports (It takes me opening all of them it seems) then automagically the first report works.

I should note that this is not my Database, rather I inherited it from my Boss. So I do not know where all the guts are and where they go.


How to get Users in 2010 ?
Forum, Converted 2000 to 2010 and resolved most issues except a little stuck on the Users issue.

In 2000 we have mdw. This works in 2010 if you use the mdb format but won't work when converted to accdb.

With mdw we have a table of Users and the group they belong to and this is referenced when opening the databse.

Through the database, some activities refer to the logged on user to allow buttons to be available and or know the user name for including in reports etc.

How does 2010 handle the login process and user name process ?

I have just rec'd Access 2010 Programmer's Reference by Henning, Cooper, Griffith and Dennison. 1,230 pages and I am sure the answer is in here somewhere.
Appreciate a Heads Up on what to look for as most reference appears to discuss how mdw will work if using mdb format but not a clear path to follow to change from mdw to the 2010 solution


Access 2010 Startup Form - hide ribbon
In the process of converting Access 2000 to Access 2010. The following did work in Access 2010.
For the developer - opening up Access with the shift key still hides the ribbon. Added a module and code so the menus open for the developer.

Access 2010
Access Options - Current Database - Display Form
In the Display Form's Load Event


Selecting the main form to execute at opening a .mdb file
this is my first post in this forum. I'm new in Access, so I think you can help me in that.

I have some forms in my .mdb file. When I open my .mdb file, a form (let's call A form) is executed. Now we have created a new form with more features (let's call B form), so we want B form to be executed at opening the .mdb file instead of A form. B form calls A form, so we don't want forms names to be changed


Access 2010 to Access 2003
I have been reading for what seems like forever but haven't seen the exact words I need to in order to make a decision. I am trying to decide between Office 2007 and Office 2010. I am wondering if Access 2010 can open, use, and save Access 2003 *.mdb file format.

I have found the following quote and when reading its suggestion it would lead me to believe it would but then there is that little warning that "Because Access 2010 has many similarities with Office Access 2007, such as the same native file format," I'm not totally convinced.

Migration considerations
When you plan a migration to Access 2010, changed, and removed for Access 2010. Because Access 2010 has many similarities with Office Access 2007, such as the samenative file format, you can also review and use the existing migration documentation for Office Access 2007 when you migrate to Access 2010.

So my question is can Access 2010 open, use, and save databases in the Office 2003 file format?


Access 2010 form opening as read only
I have developed a database in Access 2003 which is used in a networked environment. and when opening some forms in this version the add recordsbutton is disabled in the navigational toolbar.


Access waits for Excell
I have an mdb report that opens an XLS file. The XLS has an query table that updates on opening with data from the mdb file, table X.
Now I want to change the data in table X and everytime, open the xls, print the contents and close. I have made the code for the XLS file so that on opening it prints and closes. My problem is that I want Access to wait until the file is closed and then generate new data in table X and so on.

For opening the excel I used

Call Shell(stAppName, vbMinimizedNoFocus)

If you're asking why the hell I'm doing this, well , it's some sort of pagebreaking on a report. Making it separate worksheets won't work as I may have to many sheets for excel to handle