2003 mdb will not open for editing!

January 4, 2009 at 19:23:36
Specs: Windows XP, Pent. D - 512Mb
Hi folks,
I've been building a basic Access database (Office 2003 - Win XP) for my work on a laptop they've supplied.

I've placed the .mdb file on a flash drive and brought it to work so I can continue on it there.

However, when I try to open it I can only enter data through the main form - I cannot edit the database structure (tables, forms, VBA) in any way and the menu options available are greatly restricted so I cannot do anything with it.

I have not invoked any sort of security on any level and the file is not read only.

I tried to find out as much as I could before this post, but the few 'solutions' I came across like holding Ctrl while opening the file etc. were completely useless.

Can anyone help me?

Much appreciated in advance.


See More: 2003 mdb will not open for editing!

Report •


#1
January 5, 2009 at 04:47:21
It sounds as if there was Security placed on the database. You'll need the Workgroup Security file copied to your system.

Just an FYI, in future Access questions are better answered in the Database Forum.

"So won’t you give this man his wings
What a shame
To have to beg you to see
We’re not all the same
What a shame" - Shinedown


Report •

#2
January 6, 2009 at 17:43:26
Thanks Jennifer,
Is it too much to ask where said file may be located?

Thanks again


Report •

#3
January 7, 2009 at 06:59:18
You'll need to obtain the file from the person who created the database.

Off the top of my head, I can't remember the location for it, (or the exact name), but it may be system.mdb. Again, I'm not positive as I haven't worked with secured Access databases in nearly ten years. The database administrator should know.

"So won’t you give this man his wings
What a shame
To have to beg you to see
We’re not all the same
What a shame" - Shinedown


Report •

Related Solutions


Ask Question