MS Access DB access....
Hi
I created a program using VB6.0 and i made a setup file for it. When i tried to install it on other PCs, it worked fine under Admin accounts but when using Limited account user, the program couldn't open because the database was not opened. I got this error message (Microsoft DB Engin couldn't open "my DB path" because it might be opened execlusivly or you dpon't have permissions to view it)... do you know how to make a VB6.0 program supports multi-different users... thanks
[506 byte] By [
Gundam] at [2007-11-20 11:40:15]
# 2 Re: MS Access DB access....
Well, thank for your advise BUT that didn't solve the problem...
--------
here more info:
I use Microsoft DAO3.51 to connect the MS Access DB.
ans i use this code:
Set MyDB = DBEngine.Workspaces(0).OpenDatabase(App.Path & "MyMSAccessDB", False, False, ";PWD=MyPassword")
Gundam at 2007-11-9 19:33:42 >
# 3 Re: MS Access DB access....
DAO is old. Look into ADO. Keep in mind that Access doesn't like more than 5 or so users at once. It's not SQL Express.
# 4 Re: MS Access DB access....
Well, i'm talking about using MS Access DB by more than one user at once. I meant, if i intall the program on a PC and run it under Admin User Account , it works fine BUT when i run it using Limited User Account it wouldn't run properly cos Microsofte Engine couldn't open the MS Access DB of the program.
I wonder if thia has anything to do with coding in visual basic itself; like giving permissions to whatever user accounts types.
Gundam at 2007-11-9 19:35:52 >
# 5 Re: MS Access DB access....
Try right-clicking on the exe and selecting RUN AS, then log on as admin to see if it works. That will narrow down the issue.
# 6 Re: MS Access DB access....
Well, first thans for ur effort trying to help me.
I tried what u suggested BUT it still didn't work ????
There must be some way to make ur program runnable under any type of user accounts. I mean nowadays u can see many of program run under any user account of any type (admin or limited).
hopw anyone can help... thanks
Gundam at 2007-11-9 19:37:48 >
# 7 Re: MS Access DB access....
This looks like a workaround:
http://blogs.msdn.com/aaron_margosis/archive/2004/07/24/193721.aspx
