Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multiple access to Access

Status
Not open for further replies.
guymason

guymason

Technical User
Apr 25, 2001
125
0
0
GB
Help, we have inherited an Access97 data base that is going live on Monday morning, but is refusing to let more than one person use it at a time?
 
Sort by date Sort by votes
Well if you have tested a different database in the same exact client-server distribution, and it works, then it would be a problem with this specific database. If you've already tried compacting and repairing, try creating a new shell database, and importing all objects into it, then renaming the new shell to the name of the real database. This often solves 'mysterious' problems.
 
Upvote 0 Downvote
Check Tools,Options, click Advanced tab, make sure db is set to shared.
 
Upvote 0 Downvote
gonna try compact and repair, thanks
 
Upvote 0 Downvote
Compact and repair didn't make any difference.
 
Upvote 0 Downvote
and neither did importing in to a new database.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Using Access Database Without Having MS Access
Replies
9
Views
290
grnzbra
grnzbra
OCM
  • Question
Populate access table from excel
Replies
6
Views
233
OCM
OCM
TheresAlwaysAWay
  • Locked
  • Question
Can Access be used to generate and respond to text messages? 1
Replies
6
Views
168
TheresAlwaysAWay
TheresAlwaysAWay
lmcate
  • Locked
  • Question
How to Open ACCESS (MDB) from an HTML Page 1
Replies
2
Views
173
lmcate
lmcate
Moss100
  • Locked
  • Question
Upgrading from Access 2013 - whats the best option
Replies
2
Views
141
Moss100
Moss100

Part and Inventory Search

Sponsor

Back
Top