Ms Access Question?

Question

Has anyone split a microsoft access database and tried too implement it over a wireless network (54mbps)?

Is there anyway I can increase the performance, as it keeps crashing and running very slowly (a lot slower than sharing the unsplit / complete database etc and dumping the whole thing in a shared folder).

Thanks for answers in advance

Split...
Means you can split the database into the back end (tables) and front end interfaces queries and macros and reports.
The idea being that you only transmit the information over the network and not the whole shabboogle.

Thanks everyone...

I imported the tables into a seperate database, the forms etc into another database, compacted and repaired...and all of this must have reset all the defaults - as it has sped up considerably..
Thanks again.

Answer 1

I frequently enter databases on a network through a 54mbps wireless connection for my work - I've never had a problem. Perhaps the wireless connection isn't the cause of your anguish!

Rawlyn.

Answer 2

I guess I am kinda confused as to what you mean by 'split'. But, the problem here sounds more like the wireless network then anything. I would not suggest using an MS Access DB over a wireless network - too many bad things can occur especially if you are doing row-level updates.

I currently have an Access database deployed over our hardwired network here that works great and supports close to 30 users at once. No problems.

Answer 3

Access is intended to run on the local machine, not across a network. If you need remote access, consider putting it up on a Terminal Server or porting it to SQL Server.