Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
GrantMason
Starting Member
7 Posts |
 Posted - 2001-12-29 : 10:55:33
|
| Hi - I wonder if anyone can help please.I am getting the error message INVALID OBJECT NAME 'NEW' whenever I try to add a record via a query or form that has fields in it from more than one table. Have tried various options but no success - can anyone help?I am using SQL server 2000 back end with Access 2002 front end.Thanks.Grant Mason |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2001-12-29 : 11:04:05
|
| the Error says you dont have a object named 'new' ,in your case table named new. you are trying to add a record in this table which isnt in your database. check your table name properly and check whether it exists in the database. btw, to proper naming convention to any object is databasename.username.objectnameHTH-------------------------Graz's Baby is my Master:) |
 |
|
|
GrantMason
Starting Member
7 Posts |
Posted - 2001-12-29 : 12:13:51
|
| Thanks for your reply.This problems occurs whatever tables I use and I make no reference to a table or object with 'new' in its name at all. It only happens when I try to add a record to a table via a query with two or more joined table, and not with a query with only one table.Here is one example, from a table that logs telephone calls that references the 'For' field to a second table of User Information.SELECT dbo.[Telephone Log].*, dbo.Users.*FROM dbo.[Telephone Log] INNER JOIN dbo.Users ON dbo.[Telephone Log].[For] = dbo.Users.UserIDPerhaps you can figure out what I'm doing wrong from this.Thanks again.Grant Mason |
|
|
|
Nazim
A custom title
1408 Posts |
Posted - 2001-12-29 : 23:56:57
|
| Hi Grant,can you provide the code you are writing for inserting you records. might be we could find something from it.btw ,do u have proper right's on the tables u r using? . check that too.-------------------------Graz's Baby is my Master:) |
|
|
|
|
|
|
Invalid Object Name 'New'