N
Nich
I'm using SQL Server 2005 as my backend and Access 2003 adp as my front end.
Table
tblBuilding, tblBuildingRoom, tblRoom
BldgID BuildingRoomID RoomID
BldgName BldgID rmNumber
BldgAddress RoomID
I make my first form with all of the tblBuilding fields.
I make a subform with
BuildingRoomID,BldgID, RoomID form the tblBuildingRoom along with the
RoomID, rmNumber from the tblRoom table.
When I go to update,add or save a recored I get the following two error
messages and I'm not able to figure out how to fix them any help would be
greatly appriciated.
Syntax error or access violation.
I hit ok
At this point I can not do anything else on the form.
I close the form and get the following error message.
You can't save this record at this time!
Microsoft Access may have encountered an error while trying to save a record.
If you close this objec now, the data changes you made will be lost.
Do you want to close the database object anyway?
yes no
However when I press yes and look in the sql server I can find the record
that I added, so I'm not sure why I'm getting the above error messages.
Table
tblBuilding, tblBuildingRoom, tblRoom
BldgID BuildingRoomID RoomID
BldgName BldgID rmNumber
BldgAddress RoomID
I make my first form with all of the tblBuilding fields.
I make a subform with
BuildingRoomID,BldgID, RoomID form the tblBuildingRoom along with the
RoomID, rmNumber from the tblRoom table.
When I go to update,add or save a recored I get the following two error
messages and I'm not able to figure out how to fix them any help would be
greatly appriciated.
Syntax error or access violation.
I hit ok
At this point I can not do anything else on the form.
I close the form and get the following error message.
You can't save this record at this time!
Microsoft Access may have encountered an error while trying to save a record.
If you close this objec now, the data changes you made will be lost.
Do you want to close the database object anyway?
yes no
However when I press yes and look in the sql server I can find the record
that I added, so I'm not sure why I'm getting the above error messages.