•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Visual Basic 4 / 5 / 6 section within the Software Development category of DaniWeb, a massive community of 426,593 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 1,656 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums
Views: 6605 | Replies: 3
 |
•
•
Join Date: Nov 2004
Posts: 2
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Hello,
I can not fill a dataset and operate with a datatable when it is on other computer (not on the ASP server). I am using MS VIsual Studio .NET 2003 and ASP. I receive the following error when trying to fill a dataset:
"The Microsoft Jet database engine cannot open the file '\\path' It is already opened exclusively by another user, or you need permission to view its data."
I have checked the permissions, everything seems to be OK. I receive the same error when trying to operate with a database on the same machine the ASP server is, if it has a linked table in a file on another computer.
Thanks,
Aleksander
I can not fill a dataset and operate with a datatable when it is on other computer (not on the ASP server). I am using MS VIsual Studio .NET 2003 and ASP. I receive the following error when trying to fill a dataset:
"The Microsoft Jet database engine cannot open the file '\\path' It is already opened exclusively by another user, or you need permission to view its data."
I have checked the permissions, everything seems to be OK. I receive the same error when trying to operate with a database on the same machine the ASP server is, if it has a linked table in a file on another computer.
Thanks,
Aleksander
•
•
Join Date: Dec 2004
Location: Boston, MA
Posts: 4
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Re: Can not fill dataset from database on other computer with ASP .NET and MS Access
#2
Dec 21st, 2004
Have you found a solution/explanation for this yet? I'm experiencing the exact same issue. Is this something that I can't do anyway?
•
•
•
•
Originally Posted by Alex123
Hello,
I can not fill a dataset and operate with a datatable when it is on other computer (not on the ASP server). I am using MS VIsual Studio .NET 2003 and ASP. I receive the following error when trying to fill a dataset:
"The Microsoft Jet database engine cannot open the file '\\path' It is already opened exclusively by another user, or you need permission to view its data."
I have checked the permissions, everything seems to be OK. I receive the same error when trying to operate with a database on the same machine the ASP server is, if it has a linked table in a file on another computer.
Thanks,
Aleksander
•
•
Join Date: Nov 2004
Posts: 2
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Re: Can not fill dataset from database on other computer with ASP .NET and MS Access
#3
Dec 22nd, 2004
•
•
•
•
Originally Posted by electronym
Have you found a solution/explanation for this yet? I'm experiencing the exact same issue. Is this something that I can't do anyway?
•
•
Join Date: May 2005
Posts: 1
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Re: Can not fill dataset from database on other computer with ASP .NET and MS Access
#4
May 9th, 2005
Just wanted to let you know I have had these issues with Access. It could be several things. One, someone locked up the database when they were in it, causing the lock file to remain. Reboot both the server and workstation and that usually fixes things.
Another case I found was that the username and computername were the same. This was an issue with XP. I don't know who set that up, but BAD news! Once I changed the computername, it wasn't an issue.
If the security or permissions are not setup properly, this can also happen. It seems that you have that option taken care of. If you browse to that location and can copy and paste files, you shouldn't have any problems with the security. (If that is the security needed)
Also, make sure everyone is using the latest mdac and jet. MS didn't do a very good job with their jet. That's for sure...
Hope this helps.
Bob
Another case I found was that the username and computername were the same. This was an issue with XP. I don't know who set that up, but BAD news! Once I changed the computername, it wasn't an issue.
If the security or permissions are not setup properly, this can also happen. It seems that you have that option taken care of. If you browse to that location and can copy and paste files, you shouldn't have any problems with the security. (If that is the security needed)
Also, make sure everyone is using the latest mdac and jet. MS didn't do a very good job with their jet. That's for sure...
Hope this helps.
Bob
|
•
•
•
•
•
•
•
•
DaniWeb Visual Basic 4 / 5 / 6 Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
•
•
•
•
.net access ajax asp backup breach code combo computer custom daniweb data data protection database dell design developer developers development dom dropdownlist feed government hacker linux microsoft module msdn net news normalization operating reader reuse sans security server skin software sql survey system theme vista weather web windows xml xoap xp
- Connecting to a SQL server on another XP computer (VB.NET)
- How to delete record from Datagrid and not from Database (ASP.NET)
- It's all about datagrid (VB.NET)
- I need help..urgently (VB.NET)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: Good books for creating a chart/graph in VB
- Next Thread: How can i change the Reignal setting of Computer
