[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 140
  • Last Modified:

Win98 users can not access an ACCESS application after it was moved to Win2000 server


The microsoft jet database engine cannot open the file .... it is already opened exclusively by another user, or you need permission to view its data.

I moved an Linked table Access application from a Novell server to a Win2000 server.   All win2000 users can work with the application.  Win98 users can not open the linked file.  They can open the file that has the schema, but when they try to navigate through the records (this is a linked Access Application), they get the above error.  If users log in from a Win2000 machine, they can open the application and navigate through the records.  
Win98 users can not even copy the linked portion of the application through Windows and get Access denied.   Any idea?

  Anna
0
ad1332
Asked:
ad1332
  • 3
  • 2
1 Solution
 
DoTheDEW335Commented:
You made sure the users are loggin into the Win2000 Server correctly and have the right permission/writes?
0
 
ad1332Author Commented:
I mapped a drive to Win200 server from Win98 machine.  Went to the folder that has the application.  Created a file, edit it, save and deleted it with no problem.
0
 
DoTheDEW335Commented:
someone had that error before and tried this:

This happens to me all the time since I changed to a computer with Windows 2000 pro - on Win 98 never had the problem.
It happens after you open the Access database. The only way I found to fix it, was to create another folder, for example "database1", copy the DB into it, than delete the folder were the DB was before. Now rename "database1" to "database" - assuming this is the name of the original folder.
Now go to Windows Explorer, find the folder, right click on it, click properties, then security tab > click Everyone > check full control > Apply

If anybody else knows an easier way, I'd love to know it.

not sure how it'll apply but it's worth a shot i'd think.

source:http://www.webmasterworld.com/forum47/959.htm
0
 
ad1332Author Commented:
DoTheDEW,
Thanks for your suggestion.  It worked.  I copied the problem file to WIN98 machine from a CD.  Since it wouldn't let me access it any other way through the network.   Then I over wrote the file on the server(WIN2000) from WIN98 machine.  Some how it corrected all the broken links and now both users can access the files.  I don't know why exactly, but I like the result.
Thanks for your help.
0
 
DoTheDEW335Commented:
Good to hear, your welcome. Thanks for the accepted answer.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now