new records are not updateable

Hi,
In access, a form creates a new record. This record is not updateable -
message says that someone else is editing the record. However, in EM, the
record is updatable.
What a I doing wrong?
Do I need to supply further info?
cheers,
NEILNeil,
Might have better luck on this one by posting to the ACCESS NG. However,
you might check the 'Default open mode' for the .mdb on the Advanced tab of
Tools-Options in Access. (i.e., shared or exclusive)
HTH
Jerry
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:di3k5d$ja$1$830fa17d@.news.demon.co.uk...
> Hi,
> In access, a form creates a new record. This record is not updateable -
> message says that someone else is editing the record. However, in EM, the
> record is updatable.
> What a I doing wrong?
> Do I need to supply further info?
> cheers,
> NEIL
>|||When you edit data in a data bound form in MS Access, it uses a client side
cursor. Perhaps you need to confirm that the CursorType property is defined
as Dynamic so inserts, updates and deletions by other users are visible:
http://msdn.microsoft.com/library/d...sortypeenum.asp
Also, perhaps use of the Recordset.Resync method:
http://msdn.microsoft.com/library/d...>
doresync.asp
"Neil Jarman" <neil@.tNOiSPAMvPLEASEy.co.uk> wrote in message
news:di3k5d$ja$1$830fa17d@.news.demon.co.uk...
> Hi,
> In access, a form creates a new record. This record is not updateable -
> message says that someone else is editing the record. However, in EM, the
> record is updatable.
> What a I doing wrong?
> Do I need to supply further info?
> cheers,
> NEIL
>

new problem - RESTORE

I thought I have successfully restored a backup from another instance of
MSDE, however in my .NET program I am getting an error message about the
login failed. So what I did is create a login id using sp_grantlogin. I
assume that this allows my Windows login to be authenticated. Just in case,
I also added a new login account using sp_addlogin. Those both worked.
Now when I do...EXEC sp_grantaccess to the database, I get an error:
Database cannot be opened. It is in the middle of a restore.
When I was restoring, I did the RESTORE FILELISTONLY to get the names of the
files in the backup. I then did RESTORE DATABASE using WITH and MOVE which
announced it was successful, and the two files were placed into the
directory. I thought this was it, what did I miss?
Thanks,
Brad
Make sure you use WITH RECOVERY (the default) othewise the database will be
left in a state where it is expecting to continue the restore process using
additional backup sets. Also if you are moving databases from one server to
another you will need to synchronize the users using sp_change_users_login
(see the BOL for this one).
Jim
"AllcompPC" <allcomppc@.sbcglobal.net> wrote in message
news:%23LZHQ0HEFHA.624@.TK2MSFTNGP09.phx.gbl...
>I thought I have successfully restored a backup from another instance of
> MSDE, however in my .NET program I am getting an error message about the
> login failed. So what I did is create a login id using sp_grantlogin. I
> assume that this allows my Windows login to be authenticated. Just in
> case,
> I also added a new login account using sp_addlogin. Those both worked.
> Now when I do...EXEC sp_grantaccess to the database, I get an error:
> Database cannot be opened. It is in the middle of a restore.
> When I was restoring, I did the RESTORE FILELISTONLY to get the names of
> the
> files in the backup. I then did RESTORE DATABASE using WITH and MOVE
> which
> announced it was successful, and the two files were placed into the
> directory. I thought this was it, what did I miss?
> Thanks,
> Brad
>
|||Thank you Jim. I got it and it seems to be working fine.
Brad
"Jim Young" <thorium48@.hotmail.com> wrote in message
news:eY58HwIEFHA.228@.tk2msftngp13.phx.gbl...
> Make sure you use WITH RECOVERY (the default) othewise the database will
be
> left in a state where it is expecting to continue the restore process
using
> additional backup sets. Also if you are moving databases from one server
to[vbcol=seagreen]
> another you will need to synchronize the users using sp_change_users_login
> (see the BOL for this one).
> Jim
> "AllcompPC" <allcomppc@.sbcglobal.net> wrote in message
> news:%23LZHQ0HEFHA.624@.TK2MSFTNGP09.phx.gbl...
I
>

new problem

I got the following error message when I do an insert trigger, can anyone
please help? Thanks.
Server: Msg 8115, Level 16, State 8, Procedure ADM_APRN_ins_upd_trg, Line
108
Arithmetic overflow error converting numeric to data type numeric.
The statement has been terminated.Pls post "ADM_APRN_ins_upd_trg" code, or continue using
imagination. Thanks.
Regards,
Alfred.
>--Original Message--
>I got the following error message when I do an insert
trigger, can anyone
>please help? Thanks.
>Server: Msg 8115, Level 16, State 8, Procedure
ADM_APRN_ins_upd_trg, Line
>108
>Arithmetic overflow error converting numeric to data type
numeric.
>The statement has been terminated.
>
>.
>|||Hello Alfred,
There is very little we can do here.
The problem as the error states on in line 108. I am going
to assume that it is some sort of maths function being
carried out. Whatever it is been converted into does not
like it.
Could you post that line and the 5 lines before and after
it.
Peter
"A man is never more truthful than when he acknowledges
himself a liar."
Mark Twain
>--Original Message--
>Pls post "ADM_APRN_ins_upd_trg" code, or continue using
>imagination. Thanks.
>Regards,
>Alfred.
>>--Original Message--
>>I got the following error message when I do an insert
>trigger, can anyone
>>please help? Thanks.
>>Server: Msg 8115, Level 16, State 8, Procedure
>ADM_APRN_ins_upd_trg, Line
>>108
>>Arithmetic overflow error converting numeric to data
type
>numeric.
>>The statement has been terminated.
>>
>>.
>.
>

New Database Error Message

I am relatively new to SQL Server. I created a new
database with (and without) the new database wizard.
When I get to the end of the wizard, I get an error
message [error 1038] indicating that I cannot use empty
object or column and should use a space instead. The new
database gets created and is listed in the tree diagram.
I get a similar error message when I open the new
database and try and add a new table to it. I am running
on the local server. Anyone have any ideas?
Thanks.
Joe
I have never run across this error but do you have spaces in any of your
object names by any chance?
Andrew J. Kelly SQL MVP
"Joe" <josephmicheli@.sbcglobal.net> wrote in message
news:740101c494d6$7bc4be20$a601280a@.phx.gbl...
> I am relatively new to SQL Server. I created a new
> database with (and without) the new database wizard.
> When I get to the end of the wizard, I get an error
> message [error 1038] indicating that I cannot use empty
> object or column and should use a space instead. The new
> database gets created and is listed in the tree diagram.
> I get a similar error message when I open the new
> database and try and add a new table to it. I am running
> on the local server. Anyone have any ideas?
> Thanks.
> Joe
|||The the new database I created was a default created by
the wizard. The wizard did not allow me to add/modify any
of the objects in the database. I believe it uses
the "model" database that comes with SQL Server 2000. When
I compared the new one to the model, the number of tables
were the same (19) and the table names looked to be the
same.
>--Original Message--
>I have never run across this error but do you have spaces
in any of your[vbcol=seagreen]
>object names by any chance?
>--
>Andrew J. Kelly SQL MVP
>
>"Joe" <josephmicheli@.sbcglobal.net> wrote in message
>news:740101c494d6$7bc4be20$a601280a@.phx.gbl...
new[vbcol=seagreen]
running
>
>.
>
|||I never use the wizard so I wasn't sure what was going on and if maybe you
tried to use spaces in the DB name. You might want to get in the habit of
using commands such as CREATE DATABASE instead. This allows for much more
control and better information if an error occurs. To create a database is
pretty easy. Check out CREATE DATABASE in BooksOnLine for samples and
details.
Andrew J. Kelly SQL MVP
<anonymous@.discussions.microsoft.com> wrote in message
news:089101c494df$69d374a0$a401280a@.phx.gbl...[vbcol=seagreen]
> The the new database I created was a default created by
> the wizard. The wizard did not allow me to add/modify any
> of the objects in the database. I believe it uses
> the "model" database that comes with SQL Server 2000. When
> I compared the new one to the model, the number of tables
> were the same (19) and the table names looked to be the
> same.
> in any of your
> new
> running