Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

workgroup mdw

17 views
Skip to first unread message

kalle

unread,
Nov 17, 2009, 4:54:05 AM11/17/09
to
Hi

I have a database on a network that is located in a folder that only I
have rights. It is all very well but we want the others to be able to
access and modify data using SQL. The solution seems to be useing
system.mdw but it would not work. Am using the following.

con.Provider = "Microsoft.Jet.OLEDB.4.0"
con.Open "Data Source=I:\minmapp\mindb.mdb;Jet OLEDB:System
Database=system.mdw;"


Get an error message: "Can not open file you need permission to view
it's data"

Someone who wants to help me?

*** Sent via Developersdex http://www.developersdex.com ***

paii, Ron

unread,
Nov 17, 2009, 8:06:34 AM11/17/09
to

"kalle" <ka...@yahoo.com> wrote in message
news:4b0272bd$0$87076$815e...@news.qwest.net...

You will need to give users of the DB Create, Delete, Read, Write, Modify
rights to the Windows folder. Also each user will need to have the same
drive mapping to the DB.


kalle

unread,
Nov 17, 2009, 9:06:05 AM11/17/09
to
If I don't want them to be able to delete the file but still able to
modify the database using SQL? How do i do then?

Thanks in advance

paii, Ron

unread,
Nov 17, 2009, 9:16:43 AM11/17/09
to

"kalle" <ka...@yahoo.com> wrote in message
news:4b02adcd$0$48222$815e...@news.qwest.net...

When you open a Jet DB, it creates a lock file, the last user out will
delete the lock file. So unless you are always the 1st in and last out, your
users will need delete on the folder. Even then you may need delete. Another
choice would be to upsize the MDB to SQL Server / Express.


0 new messages