problem with open connection

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Werner S?lken - 12 Dec 2003 17:08 GMT

Hello,

on drive s:\ is a Access Db with only tables
on drive n:\ is a Access Db with forms, modules reports etc.

from drive n:\ I edit de tables on drive s:\

when I open the Db on drive n:\ , for nobody it is possible to do edit
records

the Db is Access 2003, Windows XP

What do I wrong ??

Werner

Reply to this Message

GVaught - 19 Dec 2003 05:56 GMT

Have you opened the db on drive n: exclusively? If so, this will prevent
everyone from opening the database. Your drive n database should reside on
each users drive c: not on drive n that everyone opens. Opening your
database this way is defeating the purpose of multiple concurrent users.

> Hello,
>
[quoted text clipped - 11 lines]
>
> Werner

Reply to this Message

Werner S?lken - 19 Dec 2003 16:16 GMT

link tables or "SELECT * FROM Table IN s:\with only tables...etc. is the
solution

Thanks for your reply Werner

> Have you opened the db on drive n: exclusively? If so, this will prevent
> everyone from opening the database. Your drive n database should reside on
[quoted text clipped - 16 lines]
> >
> > Werner

Reply to this Message