Access 2003 project syntax problem

[Peter Afonin]

Hello:

After I installed Access 2003 on my machine, I started to get some weird
errors when I run my project:

"Error No.:3078
The Microsoft Jet database engine cannot find the input table or query
'ahan_tblSerialsTemp'.
Make sure it exists and that its name is spelled correctly."

I have a table ahan.tblSerialsTemp, but Access doesn't like the dot in my
code anymore. If I change the dot to underscore, like this:
ahan_tblSerialsTemp - everything works.

However, I cannot change the syntax in my code, first because in most cases
the original syntax still works (like dbo.TableName), and second - I have
this problem only on the PC that has Office 2003 installed (although I use
Access 2000 file format).

Doeas anyone know anything about this problem? I would appreciate your
comments.

Thank you,

 

[Sal]

I assume you are using a .mdb file.
Rename your linked tables to the desired name
ahan_tblSerialsTemp
Access does not care what the actual name is on the
server, it will use the name you give it inside of
the .mdb file.
One problem I think I see, you may be using the name of
the table inside of the .mdb file in your code...
You sho8uld be using a connection to SQL Server instead.
Tha will give you a lot more speed. Do not use Jet at all,
it is too unstable.

Hope this helps =)

Sal

 

[Peter Afonin]

Thank you, Sal.

I'm using Access project, i.e. an .adp file, not .mdb.