Access and Excell at odds, who win's? Not me!

J

jackle

When I try to have Excell reed a specific datasource in
an Access database, It comes up with an error
mesage:
"[Microsoft][ODBC Microsoft Access Driver] The Microsoft
Jet database engine stopped the process because you and
another user are attempting to change the same data at
the same time." But I am the only one connected to this
database.

It doesn't have a problem with the smaller tables, just
this one. It only has 9000 records in it. Also for some
reason, I seem to have two records with "dates out of
range" but they're not.

If I try to export the data table, it also displays the
same message. If it actually does export, the file is
complete at 6-1/2 meg. If i take this database to another
computer, the glitch follows along.

Is it the size or a gremlin in the table?
 
R

Raghu Prakash

Hi Jackle,

SYMPTOMS
If you add a record to a Microsoft SQL Server-linked table and then try to
delete that record, you may receive the following error message:

The Microsoft Jet database engine stopped the process because you and
another user are attempting to change the same data at the same time.
CAUSE
This problem occurs if fields with a bit data type in the SQL Server-based
database have been left blank. Microsoft Access interprets blank fields as
fields that contain Null values, and the Jet database engine does not
release them. As a result, the records remain locked and are not available
for deletion.
RESOLUTION
To resolve this problem, do not allow Null values, or establish a default
value on the fields with a bit data type. To do so, follow these steps:
NOTE: To perform this procedure, you must have the appropriate permissions
to modify database objects (db_ddladmin or db_owner).


Start SQL Server Enterprise Manager, and then locate the server where the
database is located.
Expand the Databases folder, double-click the database name, and then click
Tables.
In the right pane of SQL Server Manager, right-click the table where the
field with a bit data type is located, and then click Design Table.
Under Default Value, type either 0 (zero) or 1.

NOTE: To disallow Null values, clear the appropriate Allow Nulls check box.


For Further Information : Microsoft Knowledge Base Article - 318882
http://support.microsoft.com/?kbid=318882

Please let me know has this helped You...
Thank you...
Raghu...
This posting is provided "AS IS" with no warranties, and confers no rights.
 
A

Arvin Meyer

Before doing anything, check the folder where your database resides and
delete the LDB file with the same name if it exists. That may solve your
problem, but chances are that you have a corrupt table. Try the following:

First, always work on a copy of the database. Working on the original may
make it impossible for a repair service to fix it.

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

http://www.granite.ab.ca/access/corruptmdbs.htm

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
D

Dirk Goldgar

Raghu Prakash said:
Hi Jackle,

SYMPTOMS
If you add a record to a Microsoft SQL Server-linked table and then
try to delete that record, you may receive the following error
message:
Click to expand...

Um, Raghu, the user's post strongly suggests that SQL Server is not in
the mix here.
 
J

Jackle

I ran "compact and repair databse". it took a few
seconds. Not only did if fix my problem, it reduced the
size of my bloated database to almost 1/10th the size.
Wow. And, I do no not have a SQL server. It is just a
stand-alone database. Thanks for the help, though.
 
Top