Markus

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?

trevsubwrx1

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

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

Good luck.
trev

DemonDave

iTrader: (13)

go sql server

Markus

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.

DemonDave

iTrader: (13)

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

Markus

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

DemonDave

iTrader: (13)

or even try microsofts free version