Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A

My objective is to use Enterprise Manager to move (copy) my SQL db from the server to my windows desktop computer.

I downloaded MSDE and am having trouble installing it, no doubt because I do not understand the documentaion (ReadMeMSDE2000A.htm).

When I try to run setup, I get that message that says:

"A strong SA password is required for security reasons. Please use SAPWD switch to supply the same."

Considering my purpose, do I need a "strong" SA password? If not, how do I get around it? If yes, how do I set it up?

I am a Mac user so I have poor windows skills, please make it as painless as possible for me, thanks!

RonCreate 2 file in the same director with setup.exe

1. Setup.bat
setup.exe /settings Settings.ini /L*v C:/MSDELog.log

2. Settings.ini
[Options]
SAPWD=YourPassword
DISABLENETWORKPROTOCOLS=0
SECURITYMODE=SQL
DATADIR="C:\MSDE"
TARGETDIR="C:\MSDE"

Run the setup.bat|||I have tried your code and other code like that and in each case it fails. I keep getting this error message that says:

"The instance name specified is not valid."

Note that your code didn't even use the instance name.

In your code you use:

DATADIR="C:\MSDE"
TARGETDIR="C:\MSDE"

Actually on my C drive the folder is called MSDERela. I tried changing your code to indicate that and it still doesn't work. Same error message.

Any other suggestions? Thanks!|||I added the INSTANCENAME and added quote marks to some of the code and it seems to have worked. It produced a folder on my C drive wtih a number of files in it.

Now can someone tell me how to launch MSDE?

Now you know why I call myself SQL_Dummy!sql

Microsoft SQL Server 2000 Desktop Engine

Trying to install Microsoft SQL Server 2000 Desktop Engine on my laptop. I downloaded the software and opened it to a folder on the C drive. Then from the command prompt I entered this:

C:\msderela>setup sapwd = hillary instancename=mjh targetdir=c:\mike

The program starts to install and seems to get near to the end of instal and then the progress bar starts going backwards and nothing gets installed...any ideas of what I'm doing wrong...I really don't know anything about this at all.

ThanksSounds like you've tried it a couple of time already, huh?

Bounce the box, see what you got :)|||Like I said...I know nothing about this...bounce the box? sorry for being so stupid|||ummm. Reboot? Restart? Unplug and then re-plug? Either one will work ;)|||Originally posted by rdjabarov
Sounds like you've tried it a couple of time already, huh?

Bounce the box, see what you got :)

Is it possible to do if it does not look like a box (laptop)... ;)|||I've rebooted several times and still get the same results...|||What is the OS on your laptop?|||2000 pro|||progress bar going backwards?? check if the monitor is kept upside down??|||Thanks....|||I don't know if this will help but I have attached the error log. I don't understand what it is saying.|||Where is your log file?|||I'm sending the file again|||Do you have enough hard disk space?|||I have 2.43 GB|||I'm wondering if the problem is
C:\msderela>setup sapwd = hillary instancename=mjh targetdir=c:\mike

I pasted the text from Microsoft website:

TARGETDIR="executable_folder_path"

Specifies the folder where the Desktop Engine executable files are to be installed. The default for executable_folder_path when installing a default instance is C:\Program Files\Microsoft SQL Server\MSSQL\Binn\. The default for executable_folder_path when installing a named instance is C:\Program Files\Microsoft SQL Server\MSSQL$<InstanceName>\Binn\, where <InstanceName> is the name specified in the INSTANCENAME option. The file path for this parameter must end with a backslash (\).

Read the details at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_84xl.asp|||Nope...still won't install|||Did you try to click the file Setup.exe for the installation and use the default folder?

Microsoft SQL Server 2000 Desktop Engine

I have recently installed Microsoft SQL Server 2000 Desktop Engine on a
computer. How do i create tables and stuff like I do in the standard versio
n
of SQL server? I tried connecting to it with enterprise manager but this
fails. Are you allowed to use enterprise manager with this product?
I created a dts package that deletes several database tables and reimports
the tables once a day. Ultimately I would like to run this package on this
new install of SQL desktop engine. Im not sure how to do this w/o enterprise
manager?
Any help would be greatly appreciated!-- Are you allowed to use enterprise manager with this product?
Yes the only limitation is that it is not shipped with MSDE, but it can be
used if you gotta licence from SQL Server.
Another program could be QALITE which can be downloaded for free.
--I tried connecting to it with enterprise manager but this
> fails.
This should work, what kind of error are you getting ?
Ultimately I would like to run this package on this
> new install of SQL desktop engine. Im not sure how to do this w/o
> enterprise
> manager?
You can use dtsrun.exe from the commandline to run the package if you
stored it properly(for example in a structured storage file)
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"PCL" <PCL@.discussions.microsoft.com> schrieb im Newsbeitrag
news:85CB0C41-377E-4A4D-8335-103A4AAE8488@.microsoft.com...
>I have recently installed Microsoft SQL Server 2000 Desktop Engine on a
> computer. How do i create tables and stuff like I do in the standard
> version
> of SQL server? I tried connecting to it with enterprise manager but this
> fails. Are you allowed to use enterprise manager with this product?
> I created a dts package that deletes several database tables and reimports
> the tables once a day. Ultimately I would like to run this package on this
> new install of SQL desktop engine. Im not sure how to do this w/o
> enterprise
> manager?
> Any help would be greatly appreciated!|||Thank you for your quick response and info - The QALITE program looks pretty
interesting - i have never heard of it before.
When I try to use enterprise manager. I am running it from my workstation
and am trying to register the machine that is using the desktop Engine - Whe
n
i try to do the registration it says the server either doesnt exist or i do
not have the right credentials. I am using the sa user name and the password
I gave it when i installed the desktop engine. Does enterprise manage have
to be run on the mackine that is using the desktop engine or is it the same
as a standard version of SQL server where u can manage it on a remote
workstation?
Is there anyway I can schedule my saved DTS package to run on the Desktop
Engine? I would like it to run every morning at 3AM?
"Jens Sü?meyer" wrote:

> -- Are you allowed to use enterprise manager with this product?
> Yes the only limitation is that it is not shipped with MSDE, but it can be
> used if you gotta licence from SQL Server.
> Another program could be QALITE which can be downloaded for free.
> --I tried connecting to it with enterprise manager but this
> This should work, what kind of error are you getting ?
> Ultimately I would like to run this package on this
> You can use dtsrun.exe from the commandline to run the package if you
> stored it properly(for example in a structured storage file)
>
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "PCL" <PCL@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:85CB0C41-377E-4A4D-8335-103A4AAE8488@.microsoft.com...
>
>

Microsoft SQL Server 2000 Desktop Engine

I have recently installed Microsoft SQL Server 2000 Desktop Engine on a
computer. How do i create tables and stuff like I do in the standard version
of SQL server? I tried connecting to it with enterprise manager but this
fails. Are you allowed to use enterprise manager with this product?
I created a dts package that deletes several database tables and reimports
the tables once a day. Ultimately I would like to run this package on this
new install of SQL desktop engine. Im not sure how to do this w/o enterprise
manager?
Any help would be greatly appreciated!-- Are you allowed to use enterprise manager with this product?
Yes the only limitation is that it is not shipped with MSDE, but it can be
used if you gotta licence from SQL Server.
Another program could be QALITE which can be downloaded for free.
--I tried connecting to it with enterprise manager but this
> fails.
This should work, what kind of error are you getting ?
Ultimately I would like to run this package on this
> new install of SQL desktop engine. Im not sure how to do this w/o
> enterprise
> manager?
You can use dtsrun.exe from the commandline to run the package if you
stored it properly(for example in a structured storage file)
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"PCL" <PCL@.discussions.microsoft.com> schrieb im Newsbeitrag
news:85CB0C41-377E-4A4D-8335-103A4AAE8488@.microsoft.com...
>I have recently installed Microsoft SQL Server 2000 Desktop Engine on a
> computer. How do i create tables and stuff like I do in the standard
> version
> of SQL server? I tried connecting to it with enterprise manager but this
> fails. Are you allowed to use enterprise manager with this product?
> I created a dts package that deletes several database tables and reimports
> the tables once a day. Ultimately I would like to run this package on this
> new install of SQL desktop engine. Im not sure how to do this w/o
> enterprise
> manager?
> Any help would be greatly appreciated!|||Thank you for your quick response and info - The QALITE program looks pretty
interesting - i have never heard of it before.
When I try to use enterprise manager. I am running it from my workstation
and am trying to register the machine that is using the desktop Engine - When
i try to do the registration it says the server either doesnt exist or i do
not have the right credentials. I am using the sa user name and the password
I gave it when i installed the desktop engine. Does enterprise manage have
to be run on the mackine that is using the desktop engine or is it the same
as a standard version of SQL server where u can manage it on a remote
workstation?
Is there anyway I can schedule my saved DTS package to run on the Desktop
Engine? I would like it to run every morning at 3AM?
"Jens Sü�meyer" wrote:
> -- Are you allowed to use enterprise manager with this product?
> Yes the only limitation is that it is not shipped with MSDE, but it can be
> used if you gotta licence from SQL Server.
> Another program could be QALITE which can be downloaded for free.
> --I tried connecting to it with enterprise manager but this
> > fails.
> This should work, what kind of error are you getting ?
> Ultimately I would like to run this package on this
> > new install of SQL desktop engine. Im not sure how to do this w/o
> > enterprise
> > manager?
> You can use dtsrun.exe from the commandline to run the package if you
> stored it properly(for example in a structured storage file)
>
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "PCL" <PCL@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:85CB0C41-377E-4A4D-8335-103A4AAE8488@.microsoft.com...
> >I have recently installed Microsoft SQL Server 2000 Desktop Engine on a
> > computer. How do i create tables and stuff like I do in the standard
> > version
> > of SQL server? I tried connecting to it with enterprise manager but this
> > fails. Are you allowed to use enterprise manager with this product?
> >
> > I created a dts package that deletes several database tables and reimports
> > the tables once a day. Ultimately I would like to run this package on this
> > new install of SQL desktop engine. Im not sure how to do this w/o
> > enterprise
> > manager?
> >
> > Any help would be greatly appreciated!
>
>

Microsoft SQl Server 2000 Desktop Engine

Hello Folks,

Just installed Microsoft SQl Server 2000 Desktop Engine
as instructed bySams Teach Yourself ASP.NET
After trying to connect to the database in the Connect
to database dialog box. Got this error message
"Unable to connect to the database. Login failed for user 'sa'.
Not associated with trusted SQL Server Connection."
The desktop server is on my home computer.
How to I solve this?
Thanks for any help,
Student33Hi,

What is the connection string you're using to connect to the database?

Don

Microsoft SQL Server 2000 Desktop Engine

I have recently installed Microsoft SQL Server 2000 Desktop Engine on a
computer. How do i create tables and stuff like I do in the standard version
of SQL server? I tried connecting to it with enterprise manager but this
fails. Are you allowed to use enterprise manager with this product?
I created a dts package that deletes several database tables and reimports
the tables once a day. Ultimately I would like to run this package on this
new install of SQL desktop engine. Im not sure how to do this w/o enterprise
manager?
Any help would be greatly appreciated!
-- Are you allowed to use enterprise manager with this product?
Yes the only limitation is that it is not shipped with MSDE, but it can be
used if you gotta licence from SQL Server.
Another program could be QALITE which can be downloaded for free.
--I tried connecting to it with enterprise manager but this
> fails.
This should work, what kind of error are you getting ?
Ultimately I would like to run this package on this
> new install of SQL desktop engine. Im not sure how to do this w/o
> enterprise
> manager?
You can use dtsrun.exe from the commandline to run the package if you
stored it properly(for example in a structured storage file)
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"PCL" <PCL@.discussions.microsoft.com> schrieb im Newsbeitrag
news:85CB0C41-377E-4A4D-8335-103A4AAE8488@.microsoft.com...
>I have recently installed Microsoft SQL Server 2000 Desktop Engine on a
> computer. How do i create tables and stuff like I do in the standard
> version
> of SQL server? I tried connecting to it with enterprise manager but this
> fails. Are you allowed to use enterprise manager with this product?
> I created a dts package that deletes several database tables and reimports
> the tables once a day. Ultimately I would like to run this package on this
> new install of SQL desktop engine. Im not sure how to do this w/o
> enterprise
> manager?
> Any help would be greatly appreciated!
|||Thank you for your quick response and info - The QALITE program looks pretty
interesting - i have never heard of it before.
When I try to use enterprise manager. I am running it from my workstation
and am trying to register the machine that is using the desktop Engine - When
i try to do the registration it says the server either doesnt exist or i do
not have the right credentials. I am using the sa user name and the password
I gave it when i installed the desktop engine. Does enterprise manage have
to be run on the mackine that is using the desktop engine or is it the same
as a standard version of SQL server where u can manage it on a remote
workstation?
Is there anyway I can schedule my saved DTS package to run on the Desktop
Engine? I would like it to run every morning at 3AM?
"Jens Sü?meyer" wrote:

> -- Are you allowed to use enterprise manager with this product?
> Yes the only limitation is that it is not shipped with MSDE, but it can be
> used if you gotta licence from SQL Server.
> Another program could be QALITE which can be downloaded for free.
> --I tried connecting to it with enterprise manager but this
> This should work, what kind of error are you getting ?
> Ultimately I would like to run this package on this
> You can use dtsrun.exe from the commandline to run the package if you
> stored it properly(for example in a structured storage file)
>
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "PCL" <PCL@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:85CB0C41-377E-4A4D-8335-103A4AAE8488@.microsoft.com...
>
>
sql

Microsoft Security Bulletin MS04-014

Vulnerability in the Microsoft Jet Database Engine Could Allow Code
Execution (837001)
Has anyone installed this patch yet? We ran it yesterday and now we can't
seem to manage our MSDE instance via an Access project. It simply says
(disconnected) at the top of the adp window. I've checked the Connection
proerties and everything looks good (the Test Connection) even succeeds.
I've tried with both Windows authentication and SQL Server authentication,
the tests always succeed, but the database remains disconnected. Anybody
else experiencing this problem or have suggestions as what to try?
Installed and Access project still working.
Michael Tissington
http://www.oaklodge.com
http://www.tabtag.com
"Steven Bergman" <sbergman@.newboundary.com> wrote in message
news:OBtP0Q9IEHA.3720@.TK2MSFTNGP11.phx.gbl...
> Vulnerability in the Microsoft Jet Database Engine Could Allow Code
> Execution (837001)
> Has anyone installed this patch yet? We ran it yesterday and now we can't
> seem to manage our MSDE instance via an Access project. It simply says
> (disconnected) at the top of the adp window. I've checked the Connection
> proerties and everything looks good (the Test Connection) even succeeds.
> I've tried with both Windows authentication and SQL Server authentication,
> the tests always succeed, but the database remains disconnected. Anybody
> else experiencing this problem or have suggestions as what to try?
>
|||Thanks. What versions are you using? We are on Access 2002 SP1 and MSDE
8.00.194.
What versions of Access and MSDE are you using?
"Michael Tissington" <michael@.nospam.com> wrote in message
news:OnEWxI%23IEHA.964@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> Installed and Access project still working.
> --
> Michael Tissington
> http://www.oaklodge.com
> http://www.tabtag.com
> "Steven Bergman" <sbergman@.newboundary.com> wrote in message
> news:OBtP0Q9IEHA.3720@.TK2MSFTNGP11.phx.gbl...
can't[vbcol=seagreen]
Connection[vbcol=seagreen]
authentication,[vbcol=seagreen]
Anybody
>

Microsoft ODBC Sql server driver Communication Link Failure

I get the message Microsoft [ODBC Sql server driver]communication link failure error message in my VB 6 application with MSDE engine. This error does not happen often.
My connection string is as below.

"Provider=MSDASQL;Driver={SQL Server};Server=" & mSvrName & ";DATABASE=cnsClient;uid=uid;pwd=pwd"

Please help.Were you able to figure out a solution? It seems like a ODBC specific error more than a MSSQL one. I get the same error when trying execute queries against a DB2 database.

Microsoft JET Databse Engine Error Message

Hi,
When I try to import DBF files into the SQL Server,
I got the following error messages for some files.

Error Source: Microsoft JET Databse Engine
Error Destination: External table is not in the expected
format
Context: Error calling OpenRowset on the provider.

Does anyone know about this error?

I found that only files that have *.FPT (memo) files didn't work
and other files were imported successfully/

I installed sql server service pack and I checked that
the machine has the latest JET Database engine (4.0).

I'm using Microsoft SQL Server 2000 Standard Edition
w/ Service Pack 2 & Microsoft FoxPro 2.6.

Thank you in advance.

- Hyung -Did anyone ever answer this?sql

Metadata Repository Engine

How do I verify that the Metadata Repository Engine was updated to version
3.0 when I installed SQL 2000. The Help file says that if the engine is at
3.0 that I should be able to upgrade the database to 3.0. The upgrade
button is greyed out and the version is 2.0. I have another instance on the
same physical server (different virtual server) that is running 3.0.
Thanks,
JoelCheck the version for repodbc.dll. It should be version
2000.0.x.x
which corresponds to SQL 2000, repository v. 3.
I thing the v2 engine had the version of the file at
6.10.x.x or 6.0.x.x
You can find more specific info on your version by entering
the file name at the following site:
http://support.microsoft.com/default.aspx?scid=/servicedesks/fileversion/dllinfo.asp
-Sue
On Thu, 2 Oct 2003 10:36:05 -0500, "Joel Donaldson"
<jdonaldson@.centiv.com> wrote:
>How do I verify that the Metadata Repository Engine was updated to version
>3.0 when I installed SQL 2000. The Help file says that if the engine is at
>3.0 that I should be able to upgrade the database to 3.0. The upgrade
>button is greyed out and the version is 2.0. I have another instance on the
>same physical server (different virtual server) that is running 3.0.
>Thanks,
>Joel
>

Message says another user accessing data

My Access database as link SQL Server tables. I am trying to remove records
from a subtable and getting this message:
The Microsoft Jet database engine stopped the process becuase you or another
user are attempting to change the same data at the same time.
This isn't the case, however. No one else is on the Database ( I have a
tool which displays the users) and if they were, I am working with test
records which noone would have an interest in viewing.
This happened on a table before, but cleared up when I shut down the
database and opened it again. Now I can't delete the records.
Any help is appreciated.
God Bless,
Mark A. Sam
Mark A. Sam wrote:
> My Access database as link SQL Server tables. I am trying to remove
> records from a subtable and getting this message:
> The Microsoft Jet database engine stopped the process becuase you or
> another user are attempting to change the same data at the same time.
> This isn't the case, however. No one else is on the Database ( I
> have a tool which displays the users) and if they were, I am working
> with test records which noone would have an interest in viewing.
> This happened on a table before, but cleared up when I shut down the
> database and opened it again. Now I can't delete the records.
> Any help is appreciated.
Add a Timestamp column to the table on the server and make sure any bit fields
do not allow Nulls. Links below explain reasons for this to occur.
http://support.microsoft.com/default...kb;en-us;96897
http://support.microsoft.com/default...b;en-us;280730
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
|||Rick,
The table had a time stamp, but a bit filed I just added was allowing nulls.
When I unchecked and tried to save I got this error:
'Customer ST Products Tasks' table
- Unable to modify table.
ADO error: Cannot insert the value NULL into column 'TestRecord', table
'STSIData.dbo.Tmp_Customer ST Products Tasks'; column does not allow nulls.
INSERT fails.
The statement has been terminated.
I don't know what this means since it was checked to allow nulls.
I am working remotely through terminal services and don't have the use of
Project Manager, so I set up a project in Access 2000 to modify the tables.
That could be the problem, I don't know. I tried removing the field and
reentering it, unchecking the 'AllowNulls' checkbox with the same problem.
God Bless,
Mark
"Rick Brandt" <rickbrandt2@.hotmail.com> wrote in message
news:IdJIe.6467$6D5.722@.newssvr29.news.prodigy.net ...
> Mark A. Sam wrote:
> Add a Timestamp column to the table on the server and make sure any bit
fields
> do not allow Nulls. Links below explain reasons for this to occur.
> http://support.microsoft.com/default...kb;en-us;96897
> http://support.microsoft.com/default...b;en-us;280730
> --
> I don't check the Email account attached
> to this message. Send instead to...
> RBrandt at Hunter dot com
>
|||You have to ensure all your bit fields have either a TRUE (1) or FALSE (0)
Value and NO NULL value.
The reason is, several of the records in your table have null values... when
you try to modify the design so that it does not allow nulls, it cant modify
it because there already are nulls in the table in some records.
Try running an update query on that table that converts all NULLS on the
field into 0 "UPDATE tablename set fieldname = 0 where fieldname is null"
then try to modify your table Again
"Mark A. Sam" wrote:

> Rick,
> The table had a time stamp, but a bit filed I just added was allowing nulls.
> When I unchecked and tried to save I got this error:
> 'Customer ST Products Tasks' table
> - Unable to modify table.
> ADO error: Cannot insert the value NULL into column 'TestRecord', table
> 'STSIData.dbo.Tmp_Customer ST Products Tasks'; column does not allow nulls.
> INSERT fails.
> The statement has been terminated.
>
> I don't know what this means since it was checked to allow nulls.
> I am working remotely through terminal services and don't have the use of
> Project Manager, so I set up a project in Access 2000 to modify the tables.
> That could be the problem, I don't know. I tried removing the field and
> reentering it, unchecking the 'AllowNulls' checkbox with the same problem.
> God Bless,
> Mark
>
> "Rick Brandt" <rickbrandt2@.hotmail.com> wrote in message
> news:IdJIe.6467$6D5.722@.newssvr29.news.prodigy.net ...
> fields
>
>
|||There aren't any Null values. In fact I am able to delete new records, but
there is a batch that I am unable to remove. When I added the Field, the
system entered 0 to the existing records.
"TNB" <TNB@.discussions.microsoft.com> wrote in message
news:509E4A52-DE3B-4B03-9996-2DA7698B7DCB@.microsoft.com...
> You have to ensure all your bit fields have either a TRUE (1) or FALSE (0)
> Value and NO NULL value.
> The reason is, several of the records in your table have null values...
when
> you try to modify the design so that it does not allow nulls, it cant
modify[vbcol=seagreen]
> it because there already are nulls in the table in some records.
> Try running an update query on that table that converts all NULLS on the
> field into 0 "UPDATE tablename set fieldname = 0 where fieldname is null"
> then try to modify your table Again
> "Mark A. Sam" wrote:
nulls.[vbcol=seagreen]
nulls.[vbcol=seagreen]
of[vbcol=seagreen]
tables.[vbcol=seagreen]
problem.[vbcol=seagreen]
time.[vbcol=seagreen]
bit[vbcol=seagreen]
|||Well this clear up for no apparent reason other than prayer. ;)
"TNB" <TNB@.discussions.microsoft.com> wrote in message
news:509E4A52-DE3B-4B03-9996-2DA7698B7DCB@.microsoft.com...
> You have to ensure all your bit fields have either a TRUE (1) or FALSE (0)
> Value and NO NULL value.
> The reason is, several of the records in your table have null values...
when
> you try to modify the design so that it does not allow nulls, it cant
modify[vbcol=seagreen]
> it because there already are nulls in the table in some records.
> Try running an update query on that table that converts all NULLS on the
> field into 0 "UPDATE tablename set fieldname = 0 where fieldname is null"
> then try to modify your table Again
> "Mark A. Sam" wrote:
nulls.[vbcol=seagreen]
nulls.[vbcol=seagreen]
of[vbcol=seagreen]
tables.[vbcol=seagreen]
problem.[vbcol=seagreen]
time.[vbcol=seagreen]
bit[vbcol=seagreen]

Message says another user accessing data

My Access database as link SQL Server tables. I am trying to remove records
from a subtable and getting this message:
The Microsoft Jet database engine stopped the process becuase you or another
user are attempting to change the same data at the same time.
This isn't the case, however. No one else is on the Database ( I have a
tool which displays the users) and if they were, I am working with test
records which noone would have an interest in viewing.
This happened on a table before, but cleared up when I shut down the
database and opened it again. Now I can't delete the records.
Any help is appreciated.
God Bless,
Mark A. SamMark A. Sam wrote:
> My Access database as link SQL Server tables. I am trying to remove
> records from a subtable and getting this message:
> The Microsoft Jet database engine stopped the process becuase you or
> another user are attempting to change the same data at the same time.
> This isn't the case, however. No one else is on the Database ( I
> have a tool which displays the users) and if they were, I am working
> with test records which noone would have an interest in viewing.
> This happened on a table before, but cleared up when I shut down the
> database and opened it again. Now I can't delete the records.
> Any help is appreciated.
Add a Timestamp column to the table on the server and make sure any bit fiel
ds
do not allow Nulls. Links below explain reasons for this to occur.
http://support.microsoft.com/defaul...=kb;en-us;96897
http://support.microsoft.com/defaul...kb;en-us;280730
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com|||Rick,
The table had a time stamp, but a bit filed I just added was allowing nulls.
When I unchecked and tried to save I got this error:
'Customer ST Products Tasks' table
- Unable to modify table.
ADO error: Cannot insert the value NULL into column 'TestRecord', table
'STSIData.dbo.Tmp_Customer ST Products Tasks'; column does not allow nulls.
INSERT fails.
The statement has been terminated.
I don't know what this means since it was checked to allow nulls.
I am working remotely through terminal services and don't have the use of
Project Manager, so I set up a project in Access 2000 to modify the tables.
That could be the problem, I don't know. I tried removing the field and
reentering it, unchecking the 'AllowNulls' checkbox with the same problem.
God Bless,
Mark
"Rick Brandt" <rickbrandt2@.hotmail.com> wrote in message
news:IdJIe.6467$6D5.722@.newssvr29.news.prodigy.net...
> Mark A. Sam wrote:
> Add a Timestamp column to the table on the server and make sure any bit
fields
> do not allow Nulls. Links below explain reasons for this to occur.
> http://support.microsoft.com/defaul...=kb;en-us;96897
> http://support.microsoft.com/defaul...kb;en-us;280730
> --
> I don't check the Email account attached
> to this message. Send instead to...
> RBrandt at Hunter dot com
>|||You have to ensure all your bit fields have either a TRUE (1) or FALSE (0)
Value and NO NULL value.
The reason is, several of the records in your table have null values... when
you try to modify the design so that it does not allow nulls, it cant modify
it because there already are nulls in the table in some records.
Try running an update query on that table that converts all NULLS on the
field into 0 "UPDATE tablename set fieldname = 0 where fieldname is null"
then try to modify your table Again
"Mark A. Sam" wrote:

> Rick,
> The table had a time stamp, but a bit filed I just added was allowing null
s.
> When I unchecked and tried to save I got this error:
> 'Customer ST Products Tasks' table
> - Unable to modify table.
> ADO error: Cannot insert the value NULL into column 'TestRecord', table
> 'STSIData.dbo.Tmp_Customer ST Products Tasks'; column does not allow nulls
.
> INSERT fails.
> The statement has been terminated.
>
> I don't know what this means since it was checked to allow nulls.
> I am working remotely through terminal services and don't have the use of
> Project Manager, so I set up a project in Access 2000 to modify the tables
.
> That could be the problem, I don't know. I tried removing the field and
> reentering it, unchecking the 'AllowNulls' checkbox with the same problem.
> God Bless,
> Mark
>
> "Rick Brandt" <rickbrandt2@.hotmail.com> wrote in message
> news:IdJIe.6467$6D5.722@.newssvr29.news.prodigy.net...
> fields
>
>|||There aren't any Null values. In fact I am able to delete new records, but
there is a batch that I am unable to remove. When I added the Field, the
system entered 0 to the existing records.
"TNB" <TNB@.discussions.microsoft.com> wrote in message
news:509E4A52-DE3B-4B03-9996-2DA7698B7DCB@.microsoft.com...
> You have to ensure all your bit fields have either a TRUE (1) or FALSE (0)
> Value and NO NULL value.
> The reason is, several of the records in your table have null values...
when
> you try to modify the design so that it does not allow nulls, it cant
modify[vbcol=seagreen]
> it because there already are nulls in the table in some records.
> Try running an update query on that table that converts all NULLS on the
> field into 0 "UPDATE tablename set fieldname = 0 where fieldname is null"
> then try to modify your table Again
> "Mark A. Sam" wrote:
>
nulls.[vbcol=seagreen]
nulls.[vbcol=seagreen]
of[vbcol=seagreen]
tables.[vbcol=seagreen]
problem.[vbcol=seagreen]
time.[vbcol=seagreen]
bit[vbcol=seagreen]|||Well this clear up for no apparent reason other than prayer. ;)
"TNB" <TNB@.discussions.microsoft.com> wrote in message
news:509E4A52-DE3B-4B03-9996-2DA7698B7DCB@.microsoft.com...
> You have to ensure all your bit fields have either a TRUE (1) or FALSE (0)
> Value and NO NULL value.
> The reason is, several of the records in your table have null values...
when
> you try to modify the design so that it does not allow nulls, it cant
modify[vbcol=seagreen]
> it because there already are nulls in the table in some records.
> Try running an update query on that table that converts all NULLS on the
> field into 0 "UPDATE tablename set fieldname = 0 where fieldname is null"
> then try to modify your table Again
> "Mark A. Sam" wrote:
>
nulls.[vbcol=seagreen]
nulls.[vbcol=seagreen]
of[vbcol=seagreen]
tables.[vbcol=seagreen]
problem.[vbcol=seagreen]
time.[vbcol=seagreen]
bit[vbcol=seagreen]