Hi. Is there a restriction on using a variable for a table name? Such as
create function quotename_ex (
) returns nvarchar(512) as begin
create procedure [Select * from] (
[Select * from] 'pubs..[authors]'
drop function quotename_ex
drop procedure [Select * from]
> Cory Stein, MCP, MCDBA, MCSE
> >-----Original Message-----
> >Hi. Is there a restriction on using a variable for a
> table name? Such as
I've run into a problem with object name length restrictions in Access
97 while connecting to SQL Server. Objects in Access are restricted to
64 characters but SQL Server supports 128.
I have a table called 'zstblSecurityUserGroup' with a foreign key
constraint 'FK_zstblSecurityUserGroup_zstblSecurityGroup'. I put an
index on with the same same, neither name exceed 64 but when you try
to attach the table in Access it complains that it can't find the
table, I tracked the problem down to the fact that Access creates it's
virtual indices on linked tables as tablename_indexname so
does exceed the 64 characters. Access 2000 copes with this well but in
Access 97 can I get to a lower level to specify that Access not use
the table name as a prefix for the index name?
6. DAO Error