Results 1 to 2 of 2
Thread: Acc2010 Older Back End
2012-09-06, 14:25 #1
- Join Date
- Sep 2012
- Thanked 0 Times in 0 Posts
Acc2010 Older Back End
It seems that the first time one opens an mdb created in an older version of Access in Access 2010, it is read only. This is true when opening from Access or attaching to it. I don't want to convert it just use as a backend.
Somehow I overcame this last month, but now forgot how.
Now I am setting up a new machine on a client's network and running into the same prob. The file is one of a number of backends. It will allow me to open queries, but not execute action queries.
The location is C:\...XXXXXXXXX.mdb.
I moved a copy from another machine but no joy.
Setting and resetting the Read Only attribute of the file seems to not have an effect.
2012-09-06, 14:37 #2
- Join Date
- Jun 2010
- Thanked 1,398 Times in 1,221 Posts
It's not the fact that it was created with an older version, probably it's the fact that the location is not trusted. Add the folder where the database file is located to the trusted locations:
File -> Access Options -> Trust Center -> Trust Center Settings -> Trusted Locations -> Add New Location.