Executable Access DB?

[tymar]

Is it possible in any way to create an executable for an Access DB? I'm looking for a way to get around licencing issues, you know? Not everyone has Access but needs to access one Access DB.

 

[Guest_imported]

tymar, if you only need to see the information in the database, you can download a free utility 'access viewer' from hotfiles.com or download.com. This utility will allow you to inspect inside any table in your database and retreive information, but you won't be able to modify it.
There are other way, using ODBC, but you'll need to tell me from where are you accessing the database?

 

[tymar]

It will be a DB available on our LAN. Not too complicated, about equal to most inventory tracking DBs if that helps.

Anyways, what about a VB interface or html interfacing? I thought I read something about that, so would that work and how complicated would that be?

 

[Guest_imported]

Well you'll need to do a little bit of programming, but it won't be that complicated, if you have VB, you can create an application which will connect to your database using an Dabase Connection ODBC (it can also be an Internet application through a Web Page). if you're not using Win NT or 2000 as your LAN Server, you'll need to go to each client computer and configure the 'ODBC Data Sources' to map your database. Then create the application using whatever tools you have (VB, VC++, Java, etc) to connect to the ODBC source and present the information to your clients.

 

[Dreamboat]

Main page:

http://msdn.microsoft.com/library/officedev/office97/web/fulltoc.htm

Specific area:

http://msdn.microsoft.com/library/officedev/office97/web/015.htm

techsupportgirl@home.com
Brainbench MVP for Microsoft Word

http://www.brainbench.com

 

[tymar]

Thanks for the help, I'm underway with a solution using a VB interface with the DB on a server.

 

[Dreamboat]

Good luck with the project!
techsupportgirl@home.com
Brainbench MVP for Microsoft Word

http://www.brainbench.com