Having Problems with Access Projects

[Guest]

I am working on a project for an small medical office, and they want to be
able to view and work on a database at the same time in the same office. I
have the entire database in an acess database, ".mdb" but am having trouble
setting up an access project. Is an access project the best way to do this,
and if so, where can I find out how to do this?

Much Thanks

 

[Allen Browne]

The Access database (mdb) is the native Access format.

I suggest you stay with that unless you have a special reason to use
something different.

 

[Nick 'The database Guy']

Hi William,

An Access project is has the extension .adp or .ade and requires that
you have sql server. I think that what you are talking about is
spliting the database into a backend and frontend, this is where you
have the tables on a server and the front-end (with the GUI) on
individual machines. Ability to view, update and create new data is
done through linked tables.

Have I got it right?

Good luck

 

[Albert D. Kallal]

It is likely that you don't need, or nor want to create a access project.

The above requites that you install, and setup sql server....

However, if you desire the application to be multi-user, it is nice to know
that ms-access
right out of the box is multi-user....

I have some suggestions here on how you can/should setup ms-access
in this multi-user environments....

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

As a general rule, there is not really much of anything you have to do
to allow ms-access to be mult-user. However, the above idea
of splitting certainly will help your case....

 

[Guest]

Thanks so much for your help, that tutorial was very useful. I am correct in
the understanding that spliting the database into a FE and a BE will allow
two different machines to view and edit the data?

 

[Guest]

Also, I had another question. Is there a way for the other computers in the
office have just read-only access to the tables? The data entry computer
should be able to change data, but not the other comptuers.

Thanks again