db1 then db2 then db3, where they coming from

[pablavo]

Hi there

Hope someone can help. Ive recently just finished a database. At the moment the frontend is being used on the server instead of the client pc. I know this should not be the case but it's happining that way because of citrix transitions with depts which I don't really know much about yet.

Anyway. I've been looking on the Server and I can see 5 DBs named db1 through to db5

I also sometimes get the message that the DB could not compact and that it could not delete the frontend and created a new frontend.

Does anyone know why this might be? i thought it might be something to do with permissions on the server, however, I'm not really sure.

thanks in advance for any help I recieve.

 

[DJkarl]

The databases are created during the compact process, if the compact process fails to complete the database is not renamed and is left there. Not sure why this is happening exactly, if you are trying to compact over a network connection this is not all that unusual.

FYI Citrix and Access don't always play nicely together.

 

[motleyjew]

I have had that happen when multiple users try to share a database that has not been split into a frontend and a backend.

Gregg

 

[dallr]

Take off compact on close. Go to TOOLS --> OPTIONS --->GENERAL (tab). Uncheck "compact on close".

 

[pablavo]

Thanks for the input here folks.

I thought it would be something to do with the network connection. The Citrix idea's quite annoying cause if I'm working with different depts. it might limit where I can put the frontends.

I always work on a split database, usually because the backend will be in production when I'm working with a copy of the frontend, least that way any changes made to either frontend and backend will be in harmony with the live DB

Cheers

 

[dallr]

Glad to help!

Dallr