Inconsistant State

[Carl]

I have a database, created in Access 2003. It worked fine in a multi user
environment. It has a large number of macros, including an Autoexec macro.
After converting it to Access 2007 in could only support two or three users
at a time, providing a message, THe Database is in an inconsistent state and
will atempt to recover the database.........
Backups are made.
What could cause this and how do I fix it.
Thanks
Carl

 

[Tony Toews [MVP]]

I have a database, created in Access 2003. It worked fine in a multi user
environment. It has a large number of macros, including an Autoexec macro.
After converting it to Access 2007 in could only support two or three users
at a time, providing a message, THe Database is in an inconsistent state and
will atempt to recover the database.........

Is your database split into a FE and BE?

You want to split the MDB into a Front End MDB containing the queries,
forms, reports, macros and modules with just the tables and
relationships in the Back End MDB. The FE is copied to each network
users computer. The FE MDB is linked to the tables in the back end
MDB which resides on a server. You make updates to the FE MDB and
distribute them to the users, likely as an MDE.

See the "Splitting your app into a front end and back end Tips" page
at http://www.granite.ab.ca/access/splitapp/ for more info. See the
Auto FE Updater downloads page
http://www.granite.ab.ca/access/autofe.htm to make this relatively
painless.. The utility also supports Terminal Server/Citrix quite
nicely.

Note that from what I've been reading in the newsgroups folks who
don't use VBA code have been able to successfully have multiple users
in the same MDB in Access 2003. Now this may not be true any more in
A2007.

Tony

 

[Tony Toews [MVP]]

I have a database, created in Access 2003. It worked fine in a multi user
environment. It has a large number of macros, including an Autoexec macro.
After converting it to Access 2007 in could only support two or three users
at a time, providing a message, THe Database is in an inconsistent state and
will atempt to recover the database.........

Is your database split into a FE and BE?

You want to split the MDB into a Front End MDB containing the queries,
forms, reports, macros and modules with just the tables and
relationships in the Back End MDB. The FE is copied to each network
users computer. The FE MDB is linked to the tables in the back end
MDB which resides on a server. You make updates to the FE MDB and
distribute them to the users, likely as an MDE.

See the "Splitting your app into a front end and back end Tips" page
at http://www.granite.ab.ca/access/splitapp/ for more info. See the
Auto FE Updater downloads page
http://www.granite.ab.ca/access/autofe.htm to make this relatively
painless.. The utility also supports Terminal Server/Citrix quite
nicely.

Note that from what I've been reading in the newsgroups folks who
don't use VBA code have been able to successfully have multiple users
in the same MDB in Access 2003. Now this may not be true any more in
A2007.

Tony

 

[Carl]

Thank you.
I am reading on splitting and front end deployment and will give it a shot.
I am learning a lot about Access. My area of speciality has been Excel, so
I am truely a New User.
I will get back to this thread as soon a I deploy and test.

 

[Carl]

Thank you.
I am reading on splitting and front end deployment and will give it a shot.
I am learning a lot about Access. My area of speciality has been Excel, so
I am truely a New User.
I will get back to this thread as soon a I deploy and test.