Access 2007 corruption

[MarkMark]

Hello

Over the last few weeks, I've had numerous corruptions on my Access databases

Tables no longer existing
Forms dissappearing
VBA project corruption

it seems to be recurring and I wonder if anyone had experienced this, since
I have not effected any particular actions (except at one point synchronising
with Windows Mobile via DataOnTheRun)

Thanks

 

[Minton M]

Hello

Over the last few weeks, I've had numerous corruptions on myAccessdatabases

Tables no longer existing
Forms dissappearing
VBA projectcorruption

it seems to be recurring and I wonder if anyone had experienced this, since
I have not effected any particular actions (except at one point synchronising
with Windows Mobile via DataOnTheRun)

Thanks

Hi Mark,

I've found that 2007 isn't particularly stable.

I've turned off Name AutoCorrect and Compile On Demand which are a
total disaster for stability. I've moved all my data to SQL Server
Express, un-embedded all my graphics, decompiled endlessly (twice a
day), and rebuilt by importing all objects. But once a week it gets
into a bad state and forms just won't open etc. I always get
'Duplicate Declaration' errors in VBA with no indication of what the
problem is.

If it wasn't so easy to build apps with Access, I'd throw the damn
thing out the window.

-- James

 

[MarkMark]

II think there's a problem with the lock file, in particular on the hyperion
server my company uses. I get a message saying the forms are being modified
by another user and yet I am the only user.

All my forms disappear suddenly and I too have to create a new database by
importing all objects.

I get at various times the following messages:

Impossibile to find the field "objectid"
Error sending data to the OLE server
the database engine could not find the object... "digsig"
field cannot be found
database format not recognised

I had very few problems with access 97. what is going on?

 

[MikeL]

We have been on ACCESS 2007 for 1/2 a year now. We have over 100 databases
to maintain. Most work well except for the large ones. If you have over 1000
objects in your database you are going to be repairing it (or should) nearly
every time you close out. Splitting table out, using SQL server, setting your
table properties to SubdataSheet Name = [None] all help with query
performance, but there are still the issues with dealing with a large number
of objects in the same database (links still seem to count) and previous
versions of ACCESS had no problem with this.

 

[gllincoln]

Hi Mike,

I would strongly advise you to leave compile on demand turned on with Access
2007, particularly on any machine you do development on. Been there, done
that- multiple unpleasant side effects, few of them would seem to be related
to that setting. It's like gremlins got loose and are roaming around inside
your Access code.

Sincerely,
Gordon

We have been on ACCESS 2007 for 1/2 a year now. We have over 100
databases
to maintain. Most work well except for the large ones. If you have over
1000
objects in your database you are going to be repairing it (or should)
nearly
every time you close out. Splitting table out, using SQL server, setting
your
table properties to SubdataSheet Name = [None] all help with query
performance, but there are still the issues with dealing with a large
number
of objects in the same database (links still seem to count) and previous
versions of ACCESS had no problem with this.
--
Mike L

II think there's a problem with the lock file, in particular on the
hyperion
server my company uses. I get a message saying the forms are being
modified
by another user and yet I am the only user.

All my forms disappear suddenly and I too have to create a new database
by
importing all objects.

I get at various times the following messages:

Impossibile to find the field "objectid"
Error sending data to the OLE server
the database engine could not find the object... "digsig"
field cannot be found
database format not recognised

I had very few problems with access 97. what is going on?

 

[Tony Toews [MVP]]

I would strongly advise you to leave compile on demand turned on with Access
2007, particularly on any machine you do development on.

Did you mean turned on or turned off?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[MikeL]

Thank you Gordon,
I had not heard of this feature. As it turns out, my compile on demand is
turned on as well as background compile. However, I now know to check my
user's computer to see if hers is turned off. At any rate, the additional
knoweldge about this setting will come in handy.
--
Mike L

Hi Mike,

I would strongly advise you to leave compile on demand turned on with Access
2007, particularly on any machine you do development on. Been there, done
that- multiple unpleasant side effects, few of them would seem to be related
to that setting. It's like gremlins got loose and are roaming around inside
your Access code.

Sincerely,
Gordon

We have been on ACCESS 2007 for 1/2 a year now. We have over 100
databases
to maintain. Most work well except for the large ones. If you have over
1000
objects in your database you are going to be repairing it (or should)
nearly
every time you close out. Splitting table out, using SQL server, setting
your
table properties to SubdataSheet Name = [None] all help with query
performance, but there are still the issues with dealing with a large
number
of objects in the same database (links still seem to count) and previous
versions of ACCESS had no problem with this.
--
Mike L

II think there's a problem with the lock file, in particular on the
hyperion
server my company uses. I get a message saying the forms are being
modified
by another user and yet I am the only user.

All my forms disappear suddenly and I too have to create a new database
by
importing all objects.

I get at various times the following messages:

Impossibile to find the field "objectid"
Error sending data to the OLE server
the database engine could not find the object... "digsig"
field cannot be found
database format not recognised

I had very few problems with access 97. what is going on?

:

On Dec 5, 1:46 am, MarkMark <[email protected]>
wrote:
Hello

Over the last few weeks, I've had numerous corruptions on
myAccessdatabases

Tables no longer existing
Forms dissappearing
VBA projectcorruption

it seems to be recurring and I wonder if anyone had experienced this,
since
I have not effected any particular actions (except at one point
synchronising
with Windows Mobile via DataOnTheRun)

Thanks

Hi Mark,

I've found that 2007 isn't particularly stable.

I've turned off Name AutoCorrect and Compile On Demand which are a
total disaster for stability. I've moved all my data to SQL Server
Express, un-embedded all my graphics, decompiled endlessly (twice a
day), and rebuilt by importing all objects. But once a week it gets
into a bad state and forms just won't open etc. I always get
'Duplicate Declaration' errors in VBA with no indication of what the
problem is.

If it wasn't so easy to build apps with Access, I'd throw the damn
thing out the window.

-- James