Help! Cannot Open Database!

[cmrestore]

Hello all,

I am new here but I need some serious help. I spent months getting this office organized and creating a central contact database. This thing has clients, suppliers, the works. It was a lot of work.

I put it on our network server so that everyone in the office could access it. I also secured the database so that our less computer savvy project managers could "look but not touch" so to speak. We didn't want them changing anything.

Anyway, we got a new server, and the database was moved onto it. Now I can't open the database from any computer. It tells me I don't have permission. I can't even open the database on the server! If I can't get this thing open, then a LOT of time and effort are down the drain, and I'm starting over from scratch. (The backup was on the server too, and it didn't move right either apparantly, because it's not even supposed to be secured and it won't open either.) My boss is soooo not going to be happy if that happens!

Help!!!!!

[ChipR]

What version of Access were you/are you working with?
How did you secure the database?
What happens (exactly) when you try to open the database now?

[cmrestore]

I'm so lost...

I'm using Access 2000. I had never secured a database before, so I had gotten online and used a step by step instruction to secure the database. I don't really remember how I did it, but whatever the standard, easiest method is, that's probably what I used.

I'm no programmer. I'm an office assistant that dabbles in HTML and VBA. I don't really know what I'm doing, and I'm completely lost. I had a file around here somewhere with the instructions of what I did, but of course now that I actually need it again I can't seem to put my hands on it.

[cmrestore]

Opening the database

It's early, and I forgot to mention what happens when I try to open the database. I get a message that says that I don't have permissions to open the database, and to see the administrator or the person who created the database, which is of course me. This happens on every computer, including the server which is the computer the file is actually on.

[ChipR]

Unfortunately I didn't utilize the security features of previous versions of Access. At the bottom of this page, it directs you to read Access help on the topics of Workgroup Information Files, security in general, and user-level security. Hopefully by reading those topics you can determine what security features you enabled, and we can help from there. If the directions you followed involved adding code to the database, then you can stop it from running by holding down the shift key while opening the database.