Access 97 SQL Upsize Error

V

Vensia

Dear all,

I get the following error when upsize to SQL 7 :

Warning! The Upsizing Wizard has determined that you may exceed the current
SQL Server 'locks' setting if you upsize now.

Based on the size of your tables the wizard has computed that appoximately
78 locks will be needed. The current SQL Server setting is 0. You can
increase this as high as 2147483647.

Where is the lock setting for SQL Server ?
Thanks.

Vensia
 
S

Sylvain Lafontaine

This is an old bug from Access 97 and SQL-7, if I remember correctly.
Forget this error message and go ahead with the upsizing.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL Server "Locks Setting" - Access97-SQL7 Upsize 2
SQL Server does not exist or access denied (after XP SP2) 1
Error 15135 on upsizing Access to Sql Server 6
Upsizing ACC 97 to SQL 2000 1
Upsize to SQL 5
Upsize to MS SQL Access 2007 2
Access 2007 SP2 upsizing wizard is still broken. 4
Upsizing access 97 app 5

Top