Best way to distribute application

[Elain222]

Hi, I have a large database containing information that people all over the country want to access. I've designed a main form that contains 3 subforms that queries information from raw data. Now that the database is complete, i'm looking for the best way to distribute it. I've tried to put it on the network drive, but it has been rediculoursly slow. Could somebody tell me what would be the best way to do this? Thanks!

 

[ReAn]

Split the Database in 2.

Backend - Contains all the data.
Frontend - Contains the forms/queries.

Link the two with linked tables. Put the Backend on the network.

OR

Take the data and put it on an SQL/mySQL/msSQL/Oracle/whatever server.

Same idea.

Since windows networking is the suck-sauce, the 2nd option is faster, but more expensive.