DataBase Setup

R

Roy

Got a DataBase finish
the DataBase as a backend file in the server.
now i want to create a .exe file, to setup the dataBase in the Frontends.
I don't know if is Possivel, but would be a lot easy for anyone to pick the
cd, execute the file, and the file will setup the DataBase in to the
computer(Setup Wizard)

1 final detail, im not using full network address. im using Map Network
Drivers. is that means that im gonna have to Map Network Drivers in every
frontend..?

thank you.
 
J

John Vinson

Got a DataBase finish
the DataBase as a backend file in the server.
now i want to create a .exe file, to setup the dataBase in the Frontends.
I don't know if is Possivel, but would be a lot easy for anyone to pick the
cd, execute the file, and the file will setup the DataBase in to the
computer(Setup Wizard)
Click to expand...

An Access Database cannot be compiled into a .exe file.

Your options are to purchase the Visual Studio Office Extensions
package from Microsoft, which gives you a royalty-free Access runtime,
and distribute this with your frontend; or to develop the frontend in
Visual Basic (rather than in Access); or to have each user who gets a
copy of the frontend have Access installed.
1 final detail, im not using full network address. im using Map Network
Drivers. is that means that im gonna have to Map Network Drivers in every
frontend..?
Click to expand...

Yes, and you'll need to either map them all so that the same drive
letter is always used for the drive containing the backend, or add VBA
code to relink the backend when you open it.

If the users are all on a reasonably stable LAN you don't really need
an .exe file. If users are on different networks, communicating over
the Internet... you'll have some serious problems with this approach;
Access does *not* work well over a WAN using the typical
frontend/backend approach.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top