Hi there,
I'm running SQL Server 2000 on XP SP2 and have succcessfully upsized an access 2000 DB.
I have no problem opening and accessing the .adp file from the server itself using Access 2003.
I have also allowed TCP access on the server to port 1433 and I have set SQL to use port 1433 aswell as TCP/IP. The client machine has also been set to use TCP/IP on port 1433.
When I attempt to access the SQL DB file across the network, from another machine - I can successfully create a Microsoft SQL ODBC connection to the server but when I open the DB file from within Access it 'thinks' for awhile and then opens up a window with the following in the title bar:
DB name(disconnected): Database
I can't see/access any Tables etc..
Any guidance as to how I would be able to allow my remote users to connect to this DB and view the tables would be greatly appreciated.
Many thanks
Rhys L.