How to make access database multiuser

[Rameez]

Hi,

I split my database to backend and front end.

my tutor wants it to be set up on "LAN" and she should be able to use the front end...

The prob is it is working only if BE and FE are in the same folder...

now how should i proceed...

Please help me out.

 

[Rameez]

Hi,

I split my database to backend and front end.

my tutor wants it to be set up on "LAN" and she should be able to use the front end...

The prob is it is working only if BE and FE are in the same folder...

now how should i proceed...

Please help me out.

Thanks in advance

 

[MSAccessRookie]

Hi,

I split my database to backend and front end.

my tutor wants it to be set up on "LAN" and she should be able to use the front end...

The prob is it is working only if BE and FE are in the same folder...

now how should i proceed...

Please help me out.

Thanks in advance

In all LIkelihood, your able Links are defined improperly. In order for them to work on a Lan, the Links must contain the Full Address Specification of your Back End File (You will need to substitute for anything between the braces {}).

{Drive}:\{Directory}\{SubDir}\etc...\{AccessFile}.mdb}
​

To do this, Select the Tools Menu and Choose Database Utilities followed by Linked Table Manager. The Linked Table Manager will help you to fix the problem.

 

[Rameez]

Thanks a lot for being so helpful...That worked well...

One more issue...can you please suggest me on this...

in the front end, if some one holds shift and opens, then he can see the data in all the linked tables...which he is not supposed to...How to change this....


Thanks & Regards

 

[RuralGuy]

Here is a great article on MultiUser Access.

 

[Rameez]

Is there any way out...like having a lock on all tables...something like that..?

 

[Rameez]

Thanks Allan...looks like my post was put here twice...I DON'T KNOW HOW

 

[RuralGuy]

Is there any way out...like having a lock on all tables...something like that..?

Try this link: Securing AllowBypassKey