Replies

If in use by another user, then it will error & write info to log file. Unlikely tho, we’re going to be running this overnight as a service (We’ve told users again & again ‘compact your databases’, but they never do) We ran something similar to this recently & reclaimed 7GB from one server!

Well yes it’s resource hungry, but I don’t want to add to it by creating a connection – checking version & THEN compacting…!! Would take forever to run & want to keep as streamline as possible.

Thanks

If in use by another user, then it will error & write info to log file. Unlikely tho, we’re going to be running this overnight as a service (We’ve told users again & again ‘compact your databases’, but they never do) We ran something similar to this recently & reclaimed 7GB from one server!

Well yes it’s resource hungry, but I don’t want to add to it by creating a connection – checking version & THEN compacting…!! Would take forever to run & want to keep as streamline as possible.

Thanks

Managed to do it with a bit of error handling;

Try and compact with the Jet OLEDB:Engine Type=4 argument (Jet 3.X), if this errors (would for Access 2000) then try again with Jet OLEDB:Engine Type=5…

Not the most elegant of solutions but it works!

Thanks for replies…

Managed to do it with a bit of error handling;

Try and compact with the Jet OLEDB:Engine Type=4 argument (Jet 3.X), if this errors (would for Access 2000) then try again with Jet OLEDB:Engine Type=5…

Not the most elegant of solutions but it works!

Thanks for replies…

Hmmm….I’d have to create a connection to the db to determine that tho, would be too resource hungry for what my app is doing. Was hoping for an API of some sort…

Thanks anyway.

Hmmm….I’d have to create a connection to the db to determine that tho, would be too resource hungry for what my app is doing. Was hoping for an API of some sort…

Thanks anyway.

Thanks for the links Hans, very helpful.

Thanks for the links Hans, very helpful.

Thanks for reply…

Yes, it’s an ADP file, backend is MSDE for this db, but I do have the Enterprise version of SQL Server (and all client tools) for some other systems I administer.

I’m just trying to sign the user on, so that the ‘CurrentUser’ method of the Access application is set. Actual permissions aren’t the concern here, I just want to take advantage of some of Access’s functionality on the client side…

By passing the /user switch via the /wrkgrp switch, the CurrentUser method is Set and works correctly, so is there any other way to get the CurrentUser set without passing switches…?

Thanks

Thanks for reply…

Yes, it’s an ADP file, backend is MSDE for this db, but I do have the Enterprise version of SQL Server (and all client tools) for some other systems I administer.

I’m just trying to sign the user on, so that the ‘CurrentUser’ method of the Access application is set. Actual permissions aren’t the concern here, I just want to take advantage of some of Access’s functionality on the client side…

By passing the /user switch via the /wrkgrp switch, the CurrentUser method is Set and works correctly, so is there any other way to get the CurrentUser set without passing switches…?

Thanks

Thanks, I’ll give this a go…

Thanks, I’ll give this a go…

Thanks for responses people…

Mark – yes, we have an application that does all of our database launching. Whenever they launch a DB from it, it will copy a new front end to a directory local to the user. This allows us to recompile a FE and have it easily redistributed to users next time they launch the DB. Has always worked a treat in the past…

Wendell – Yes I agree totally on the SQL Server point. I’ve just got my IT director to sign off a nice $30k server with all the trimmings…! Some of the databases have 10+ users and I know Access was never intended to be a fully fledged, multi-user data store, so I’ll be converting these to SQL once I get the hardware…

Our network could indeed be flaky, we have a number of different technologies (NT Server for databases, NAS for user directories & general storage) tied together with bits of string…

Each user having a copy of the workgroup is an interesting point, hadn’t considered. Thinking about it, this could well stop the file becoming corrupted…

Thanks again everyone, will post back if I have any joy…

Thanks for responses people…

Mark – yes, we have an application that does all of our database launching. Whenever they launch a DB from it, it will copy a new front end to a directory local to the user. This allows us to recompile a FE and have it easily redistributed to users next time they launch the DB. Has always worked a treat in the past…

Wendell – Yes I agree totally on the SQL Server point. I’ve just got my IT director to sign off a nice $30k server with all the trimmings…! Some of the databases have 10+ users and I know Access was never intended to be a fully fledged, multi-user data store, so I’ll be converting these to SQL once I get the hardware…

Our network could indeed be flaky, we have a number of different technologies (NT Server for databases, NAS for user directories & general storage) tied together with bits of string…

Each user having a copy of the workgroup is an interesting point, hadn’t considered. Thinking about it, this could well stop the file becoming corrupted…

Thanks again everyone, will post back if I have any joy…

Wendell,

Thanks for the reply….

Yes, our databases are split into FE/BE, we’re experiencing corruption in the back-end of the databases. We also have a single workgroup that we are using for all of our databases & the workgroup seems to be corrupting every now and then as well! Whenever a user then tries to access a table, they receive a ‘Disk or Network Error’. We get round the problem by kicking the users out of the problem database, then simply opening any database via the workgroup? It’s bizarre…

We’re getting the same thing with VB applications using Access as a back-end, the BE corrupts perhaps 3 or 4 times a week. The advice from Citrix seems to be use latest SP’s, lastest MDAC etc etc, but the servers are all bang up to date.

We have load balancing in place on the Farm, so users are connected to the least busy server when their desktop loads. This results in multiple servers accessing a single database BE & I’ve read on the Citrix.com forums that a single server should access a multi-user BE to avoid corruption? Is this a valid point…?

I’m sick of Citrix…..it’s a good idea in theory but causing so many problems…!

Thanks