473,326 Members | 2,076 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Compact and Repair - multi user environment

MMcCarthy
14,534 Expert Mod 8TB
I know this question has been covered extensively in the past, but I'm wondering if anyone has any new thoughts on the subject. I have a Frontend/Backend Ms Access database. The frontend will be an mde.

This database will work in a multi user environment but should not be too heavily trafficed.

I know I can compact the backend by checking for ldb and compacting file to a copy file then copying back to original.

Likewise, I can compact the frontend.

I am more interested in the logic of how to handle the multi user environment and any other thoughts you may have on the subject.

By the way this is for a client and I don't want to impose any add-ins that I can't guarantee to the client.
Sep 6 '06 #1
3 4453
PEB
1,418 Expert 1GB
Hi,

What I have done on this subject in my front end back end database:

For the front end and the clients for the mde I've setuped from Tools/Options/General Compact on close

So every time when the user exit from the program his application is compacted and repaired!

Also the other thing that I'm doing is: Using a Folder from which the users copy the most recent mde files! When they have problems with their application they have to do an update and the things are ok!

But it's a problem for me the compact and repair of the Data database on the server - the back end!

All users have to exit from the application to do the compact and repair!

I want to introduce a code in my application when there is sign to quit the application Access to do it instaed of the users! But this in case of urgency!

Have a nice day!
Sep 7 '06 #2
MMcCarthy
14,534 Expert Mod 8TB
Did you give all your users their own copy of the mde on their local machines?



Hi,

What I have done on this subject in my front end back end database:

For the front end and the clients for the mde I've setuped from Tools/Options/General Compact on close

So every time when the user exit from the program his application is compacted and repaired!

Also the other thing that I'm doing is: Using a Folder from which the users copy the most recent mde files! When they have problems with their application they have to do an update and the things are ok!

But it's a problem for me the compact and repair of the Data database on the server - the back end!

All users have to exit from the application to do the compact and repair!

I want to introduce a code in my application when there is sign to quit the application Access to do it instaed of the users! But this in case of urgency!

Have a nice day!
Sep 7 '06 #3
PEB
1,418 Expert 1GB
Yes this is just that I do!

It's better for the work of the system!

Using only one copy in my case is near impossible because on their computers is copied the specified information from them from the network database!

I know that this kind of solutions don't permit the work from terminals that use remote connection!
Sep 7 '06 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Paul T. Rong | last post by:
Dear all, My aim is to compact and repair current database, I got the following code from http://www.mvps.org/access/general/gen0041.htm Option Compare Database ' ***** Code Start *****...
6
by: KEVIN97810 | last post by:
Hello to all, Assume my mdb name is Cust.MDB. I want to compact & repair the same Cust.MDB when the user exit the program. Is there a way you can do it in code behind the EXIT button. I am...
3
by: Paolo | last post by:
Hi, I am trying to compact and repair my database, however every time I try it comes up a message saying: Table: "TempMSysAccessObject already exists", whenever I try to look for this table I...
4
by: Ken Winters | last post by:
Whenever I run the Repair/Compact on my database, the security settings on the file change. A 3rd party application can only access the database over the network when the username "Everyone" is...
2
by: ApexData | last post by:
Hello I have finally completed an application and am preparing to install it on a network of 10 users. The application will be split FE/BE. The application has its own login, which controls...
2
by: Ron | last post by:
Hi All, Using WinXP pro/Access 2000. I have a database that's been used for about 5 months. Transferred lots of data from a dos based program, then the users have been using it for that 5...
9
by: Ron | last post by:
New discovery. If I take a perfectly good database, and "compact/repair" on it with Access 2000 (seems to be at multiple sites--I've tried it with my system here, at another office on an...
3
by: Bizmark | last post by:
Access2003, Windows XP Pro OEM user OS, Windows Sever 2000 server OS. Not-so-recently I inherited 3 Access DB's from another company merging with our own. Our own system works off of SQL...
4
by: zufie | last post by:
When I Repair/Compact my Access databse. I get icons/copies of a database named db1.mdb, db2.mdb, db3.mdb, etc... How else may I repair this database? Thanks!, Zuf
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.