Hi gurus,

I have upsized an access database to sql server - it works ok from my machine bit I am having access problems from other user machines -

e.g. record source not found

I also can't run SP's from the other user machines (and hence not reports either) ....

I then deleted one of the users on the database,but when I try and add them again it says they already exist ....

Confused perl guy in a sqlserver world

Any advice gratefully received

Rab

1) record source not found - You will need to update your Access forms to point to the correct DSN/ODBC setting for your SQL Server database.

2) SP's? Stored Procs? If so, then the syntax of the Access stored procs will have to upgraded to work with the SQL Server database.

3) user problems - Try first deleting the user from the access database and then delete the user in SQL Server, then re-add it.
========================================
Buh Bye!

Cheers,
Me

Cheers,

Sorted the log-in problem,record source etcc all ok ...

thanks