Build Client/Server with using Microsoft Access 2003

[March]

Hello All,

I would like to build Client/Server with using Microsoft Access 2003. I
don't know what to start; I'm new with this.

I want to share multi-databases . I write VBA in MS Access; if user selects
button "A" means access "db1.mdb", if user selects button "B" means access
"db2.mdb", and so on.

For db1 and db2, I do database splitter to separate front-end and back-end.

At this point, (I don't know that I'm wrong or not that) for button "A" and
"B" is in another .mdb file; that refer to db1 and db2 once user selected.

Another question is Do I need to use SQL Server for sharing .mdb files or not?


Please give me suggestion.


March

 

[Golfinray]

Access wil work just fine in a client server environment. Split the database
into Front End (FE) and Back End (BE) put the BE on your lan and the FE on
each users machine. Then it should be fairly easy to set up a form in your
database that the users would push a command button for one database or a
different command button for the other database.

 

[March]

Thank you for your answer.

And I have one more question that how to name the .mdb file to set current
database

What I've known is

dim db as dao.database

set db = currentdb


March

 

[March]

Anyways, Thank you . I fixed it.

Thank you for your answer.

And I have one more question that how to name the .mdb file to set current
database

What I've known is

dim db as dao.database

set db = currentdb


March