Database won't open with more than one user 2

[StarScream]

I have a database on a network drive, and for some reason, can't seem to have more than one user at a time. Never had this problem before on other databases. Is this a setting error?

Please help!
PJ

 

[donnadee]

We had this problem when an Access database was imbedded under several folders and the database rights within Access were set to the wrong level.

We added a direct link in the login script and changed the rights.

 

[wacks]

i also have this problem right now! after my boss opened the same database on his computer, i can't access it anymore on my workstation! and even worse, after he closed it, i can't go back anymore to edit my work!

to all ms access guru: i badly need your help... or i have to do all the queries, reports, etc all over again... thnx

 

[Maquis]

Wacks, first does your boss have a newer version of Access than you. If so that's the problem.

If not then I'm not sure if this is your problem or not, but I had this happen to me once.

I designed a database and sent it out to the users. Users worked just fine in the database.

I then later installed the Visual Studio suite on my computer and started merrily working in VB.

Users then called and asked for a mod to the database.

I made the mod and sent the database back to them.

Users could no longer use the database.

It turns out the problem was my &*#$% Visual Studio suite. When I opened the Access database to modify it. Access sorta looked around my hard drive and saw all these nifty new VB .dlls and decided to add them into the database. Since the users didn't have any of those nifty new .dlls they couldn't use the database.

Could your boss have VB or some other microsoft product that you don't? Maq B-)
<insert witty signature here>

 

[mulligh]

1. Make sure no copies of the program are currently open. Look for a .ldb file in the directory where you database file resides. Try to delete it. You may need to turn on the display of filename extensions. If you can't delete it, try restarting your computer.

2. If you still can't get in, create a new database and use the File--Get external data--Import and import your objects.

3. What version of Access are you using?

 

[wacks]

my main problem is that whenever i opened the mdb file, the MAIN WINDOW does not appear. i already tried the following options:

1. i created a new mdb and tried to import the tables, queries, and reports... but nothing shows from the old file

2. there is no ldb file existing coz my boss already close the mdb

3. i even open it on the server computer, but the MAIN WINDOWS still doesnt shows!

* we both have the same access 2000 version
* server is using windows 2000 pro, and client has 98 platform


this is the first time i encoutered this @#$@ problem! thnx for your help!

 

[Maquis]

Wacks, By &quot;main window&quot; do you mean the database window? If so it sounds like your boss changed the options on the database so that the database window is hidden. Have you talked to him? Did he change anything in the database or did he just open it to look at the data?

Try shifting into the database. (Hold down shift key while opening the database)


Star, sorry it seems we've taken over your thread. Are your users opening the database in exclusive mode? Perhaps that's your problem. Go under Tools --> Options and click on the advanced tab. The Default open mode should be set to shared not exclusive. Maq B-)
<insert witty signature here>

 

[wacks]

sorry starscream for taking over your thread...

maq, i tried your options but still the Main Window doesn't show up (even holding the 'shift' key before it opens)! The database is in 'share mode' and i've talked to him that he only opened the file (coz he doesn't know how to do the programming)

thnx very much but if you can still find the cure, it would be greatly appreciated!

* the funny thing is that the tables are still there coz whenever i use my ASP pages, i can still access the database... but i can't add fields or edit it anymore... i already have a back up of the tables, but not the queries and reports! thnx maq!

 

[Maquis]

ASP pages? Maybe the problem isn't your boss at all. Perhaps your web app has done something screwy to the database making it inoperable.

I can't offer any advice however, because I know absolutely nothing about web design. Just tossing it out as a possibility. Maq B-)
<insert witty signature here>

 

[wacks]

maq, it doesnt have anything to do with ASP. i just check it out if i can still use the tables inside that access database file. it shows that the tables exists and even the queries, my problem is how to show that !@$##@ MAIN WINDOW of access 2000. thnx a lot!

 

[StarScream]

Wow,

I've never had a thread hijacked before...LOL

Things seem to be working so far, only time will tell. Thanks.

PJ

 

[mulligh]

Try pressing the F11 key once the database is open.

 

[wacks]

F11 works for the VBA editor. its ok now, im making new reports and queries, and accessing tables from previous database! thnx for using your thread starscream!