Do you think this is advisable ? its easeir to develop for access instead of uploading to the server everytime you need to test has any1 done this successfully? i havnt used SQL server before any advice would help. Would the queries need to be diffrent ?

when i test on the server i get the following error

Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'LARRE\IUSR_LARRE'.

/category.asp, line 6


AMD Motherboards
ADODB.Fields error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.

/category.asp, line 267



Thanx

Use access 'upsizing wizard'.
Do a search on web for " upsizing" access to sql and you will find help.
The conversion is not perfect but close.
Have to add primary key and set auto number.
Only the very basic formats are converted correctly.