Converting old MS Access Files?

[finniganps]

Does anyone have any ideas on how to convert old MS Access files to a more current version (preferably MS Access 2000)? Currently, these are Access 1.0 files running on a Windows 95 machine. When I try to open the files in Access 2000 on Windows 2000 or XP, I get the following error:

You are trying to open a read only database

The first time you open an earlier version database, you must be able to write changes to the database.
*The database files read-only attribute may be set; clear this attribute.
*You may have chosen the Open Read Only command in the Open dialog box. Don't choose this command the first time you open the database.

Does anyone have any ideas how to open and then resave these files in a current Access format? The old ver. 1 just doesn't cut it anymore and other people can't use the database in it's current format. Thanks for your help!

 

[Crilen007]

Turn off read only.

 

[finniganps]

How do you do that in Access? Where is the option to uncheck that?

 

[The_Doc_Man]

This could a file-system "Read-Only" flag. The answer of how you fix this depends on your file system.

Find the icon for your drive that holds the DB file. It should be a drive-letter folder like C: or D: or something similar. Right-click on the icon and read all the properties. You will see that the drive is formatted one of three ways: FAT (meaning FAT16), FAT32, or NTFS. The odds are that with Win2K or WinXP, you have converted the drives to NTFS, but if it is not on your C drive, you can still use older formats.

OK, from Windows, open the folder where this DB resides.

For any version of Windows running on a FAT16 or FAT32 disk: Right-click on the file, get properties. The dialog box will include check-boxes for the file attributes including Read-Only. Clear that.

For any version of Windows running on an NTFS disk: Right-click the file to get the properties, then select the security tab. See what permissions are attached to the file. If you are the owner, you can check or uncheck stuff as you choose. You are looking for permissions that have DENY checked, or permissions that have NOTHING checked, for the boxes that say Modify or Full Control.

 

[ghudson]

This is how your turn off the Read-Only attribute of a file using VBA...

SetAttr "C:\YourFile.txt", vbNormal

Check the Access help files for more info on using the SetAttr statement.