View Single Post
  #4 (permalink)  
Old May 24th, 2007, 09:04 AM
mmcdonal mmcdonal is offline
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts

There are many options to connect Access to SQL Server (or any other DBMS) in all versions of Windows. So you can connect Access to Access, or Access to SQL Server, Access to MySSQL, etc using this method.

You can use an ODBC (DNS) in both versions of Windows. DNS's are slow, but very reliable. You also have to make sure that they are properly configured on all of your user's desktops. This can be a problem and require you to use installation software if you user base is large.

What are you doing with the front and back ends? I am assuming it is split, otherwise there is no need for a connection like this.

I do a lot of Access / SQL, and typically use a Provider statement instead of an ODBC, since I can control user credentials and the connection state.

Did any of that help?