Morning/Afternoon

In the ongoing saga of trying to get decent speed from a network hosted mutli-user access database, I thought I'd try the Base application from Open Office.

I know it can open Access databases, however, our database has some runtime front end application. Essentially we take an .mde file and change the target from:

C:\SalesDB\SalesData.mde

to

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" /runtime "C:\SalesDB\SalesData.mde"

The real question here is whether Base supports Access' runtime style databases/apps.

Does anyone know if it does?

 

Hi Markus.
not sure, but Ive found this link and forums excellent for Access help:

http://www.freeprogrammingresources.com/database.html

Good luck.
trev

 

go sql server

 

I've been considering SQL. How easy is it to take an existing Access DB, with a runtime front end and convert it over to SQL? The data side (tables, I think - I know very little about access you see) from what I can see is easy, but it's the front end bit that is somewhat confusing/worrying.

 

keep the front end and just link the tables to the sql server tables instead of the local access db that will give you a massive performance hike. It is always best to have two access dbs anyway one for the app and one for data so you can upgrade the app without worrying about the data

 

Thanks for that little tip. Am installing mySQL on my VM at the moment, so I'll have a play and see if I can do anything useful

 

or even try microsofts free version