Question Opening Access

[Angelasmith]

we have about 15 people that use an access database. some have access some use runtime. there are a couple of people on the runtime i cant get the data base to open the screen will just flash then close down.

another problem i have, and this isnt specific to runtime users is one day their database will open fine the next day when they try to open it it just opens like it is a blank database. sometimes restarting the computer works other times they have to just come in the next day and it will work again. other peoples still work when this happens. any suggestions?

we are a big government organisation and do run off a server so wondering if that has anything to do with it?

 

[bob fitz]

Your db should be split into backend/frontend. The backend would hold all the data. The frontend has everything else (forms, reports etc). Each user needs a copy of the frontend on their own machine which is then linked to the tables in the single backend. It is easy to do.
Search this forum or google for split database.

 

[Angelasmith]

thanks bob

but we already do this. I have my master file and then convert to accde for them to open but even when this problem is occuring i cant even open the master copy on their computer.

 

[way2bord]

thanks bob

but we already do this. I have my master file and then convert to accde for them to open but even when this problem is occuring i cant even open the master copy on their computer.

This could be a number of problems.

Version incompatibility - does everyone use the same version of Access? - same version of Windows? - etc. -

Intranet / network trouble - if the network hiccups on your end-user, the access front end will drop connection to backend; frontend will still open, but being unable to connect to backend, will probably error out POSSIBLY resulting in the grey screen you describe.

The list of...'Potential' problems is quite long.

My advice - start narrowing the problem down. Triple check the runtime version installed on the problem cases. Consider late binding EVERYTHING in case it's a reference error. Move a copy of the backend to the client, reconnect the frontend to that and see if errors still persist...etc.