Solved

MsAccess multi user

Posted on 2011-03-09
7
261 Views
Last Modified: 2012-05-11
It's several years I use msaccess,
but now,
is it possible make a db access which could be
used at the same time from several users?
Attention!: Not simple open and consulted,
I speak about the possibility to have tables
which are only of the current user.
For example:
I have a query1 that is a creation table query,
My user1 runs Query1 and create table1 which certain filters,
at the same time user2 runs Query1 and create table1 which his filters,

I would like if user1 has his table1 different from table1 of user2.

But they open the same db file...

Is it possible without copying the db for all different users?



0
Comment
Question by:bobdylan75
  • 4
  • 3
7 Comments
 

Author Comment

by:bobdylan75
ID: 35081309
sorry WITH certain filters and non WHICH... ;)
0
 
LVL 33

Accepted Solution

by:
jppinto earned 500 total points
ID: 35081327
You can a database for each user (local database) that has it's own tables. Then you can create a shared database on a network drive where you share the common tables, queries, forms, etc just by linking the databases. In other words, you have you own tables locally and have other tables linked on your local database from the shared database. Hope you understand the general idea...

jppinto
0
 

Author Comment

by:bobdylan75
ID: 35081550
Yes,
good idea!
I need only to have the same path on all pc,
in order to not have problem with local tables connection...
If there isn't a different technical way,
(something like table properties in msAccess),
I will close the question.
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
LVL 33

Expert Comment

by:jppinto
ID: 35081568
This is the normal way of doing things in Access. One database serves as a frontend to the user (local database) while the other serves as a backend (databae on a network drive that is shared by multi-users).

jppinto
0
 

Author Comment

by:bobdylan75
ID: 35081633
Ok,
I dont know why but,
in our network in last day
I cannot open the same db (on the network)
on different user in the same time..
there some general db property?
I will open a different question for that..
0
 

Author Closing Comment

by:bobdylan75
ID: 35081636
Ok
0
 
LVL 33

Expert Comment

by:jppinto
ID: 35081640
Thanks for the grade...Glad I helped.

regards,

jppinto
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
VBA Access 2016 syntax 6 41
object variable or with block not set 6 28
User Level Security 6 38
Change date stored as "short text" YYYYMMDD to MM/DD/YYYY? 27 26
In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question