MS Access Databse & Project

[Nano]

I have a database (file.mdb). It is fully populated and functional,
functional in a sense that the reports and queries are running fine.
Now I want to access it from network or many different people want to
access it through LAN. What should be procedure of it ?

Can it be helped via using MS AccessProject? Like I create the same
database in SQL and connect it with MS Access? In short I want to
access the reports remotely.

Regards,
Hasnain Raja

 

[Daniel]

You're going to need to split your database. Then implement user-level
security if you need to restrict access to information/forms/reports for
different users.

Once that is done you need to place the back-end on your server, the higher
in the directory structure the better (c:\ is better than
c:\subdir\subdir\subdir\). Then distribute a copy of the front-end to each
user. Typically it is best that they have the copy of the front-end on their
desktop (local pc) and not on the server. I set it up using a *.bat file on
the server. Each user has a link when they click it, it copies the front-end
into the temp folder for use. this way if I update the front-end it gets
pushed out to them the next time they click on the link. They don't even
know that it is being done.

Also, remember when working with a server, links, refs, paths should be in
UNC format. This includes linked table manager when you connect the table
from the back-end to your front-end!

 

[Nano]

Thanks Daniel, I will try working on this.

 

[jokenjo]

Nano a écrit :