Create EXE from main switchboard

[MrKovacic]

I have a database I am creating and I am trying to put the switch board on other computers on my network, but as an EXE. So all they have to do is open the program, and they can use the database through there. The database will be sitting on one computer, the EXE will sit on about 3 - 5 computers.

Thanx in Advance!!!

Mike

Thank you!!!

Mike Kovacic

""" """
(o) (O)
\____/

 

[GingerR]

you'd have to compile an exe file in VB, C++, etc....something other than Access.

 

[MrKovacic]

Ohhh, How do I get to the code? Also, what is the simplest one to do? I am truenewb at this.

Thank you!!!!!

Thank you!!!

Mike Kovacic

""" """
(o) (O)
\____/

 

[GingerR]

buy a text book, take a class as your local college.....good luck

g

 

[PJHAction]

Mike

Did you try looking at your database in a stored/user model. I manage multiple Access databases by keeping the database tables (called backend) on a server/shared drive and the database forms/queries/reports (frontend) in a different file. With this the data stays in one place and the forms can be located anywhere. Additionally, you can update forms without ever having the database down, you just redistribute the forms.

Pete

 

[MrKovacic]

How can I seperate the forms, queries etc.. from the actual database? I didnt know that was possible.

Thank you!!!

Mike Kovacic

""" """
(o) (O)
\____/

 

[PJHAction]

First, place your database where everyone can get to it, mine are in a server with a folder named "databases". This is the backend and will only contain tables! Lets say this is "Apartments".

Copy the existing backend (call it Apartment Interface&quot, this is the (frontend interface) and put it in the same place. Open frontend and delete all the tables. Then go "File", "Get External Data" and click "Link Tables". Now the interface is linked to data, not storing data. You may have to adjust your tables/queries to looked at the linked file.

Now you can email out the interface, they can put it anywhere to include desktop, My Docs, whatever. Now you can modifiy the queries/tables/forms to update the interface, then resend it out. The database is never down for maintenance.

Pete

 

[MrKovacic]

That sounds like a supurb idea. As anewb, I have alot of reading to do!

Thank you very much!

Thank you!!!

Mike Kovacic

""" """
(o) (O)
\____/

 

[MrKovacic]

I created the multi-user database and did everything you said and it works!! The only problem I am running into now is that there is no way to tell if another user is working on the record you are using.

Is there a way to have a warning, or stopper on the record if it is being used/edited by someone else??

Thanx!!

Thank you!!!

Mike Kovacic

""" """
(o) (O)
\____/

 

[MrKovacic]

I am going to re-post this thread with a different name since the subject has changed... Thank you.

Thank you!!!

Mike Kovacic

""" """
(o) (O)
\____/