Can you link tables in Access frontend to backend SqlServer on server?

Wondering if it's possible to use MS Access on the client and link to sql server tables on a server provided by discountasp.net?

Thanks for any help or answers.

 

Yep, you most certainly can!


In Access, just do:
File/New...
Click "Project using existing data..."
Name and save your adp file somewhere (You can use this to access the data in the future without following these steps)
Enter the SqlServer name (something like mssql01.discountasp.net)
Enter your user name and password
Select your database
Press OK and you are good to go!

 

I'm not sure what you mean? Do you want to use Access to modify the SQL database, or do you wantto havetables in anAccess database that somehow connect to the SQL database? Can you clarify what you are trying to do?

 

Thanks for the response. Would you also happen to know if it has to be an access project only to connect.


As in linking tables rather then having access be a sql project.

 

Ok,


I have an Access frontend with forms and stuff.


This is not an Access Project type, but a standard Access Database with forms, etc...


In this Access frontend I was wondering if I could link tables to sql which you normaly can do in a conventionalnetwork but to the sql database residing on a server as discountasp.


I would think so, but I haven't subscribed yet to test.

 

Yes, DASP is awesome about allowing software to interface with your SQL server subscription. Some hosts (*cough*,*cogodaddyugh*, *cough*)will not allow you access the database in any way unless using their web interface which is annoying to say the least.


If you know how to integrate your Access database with a local SQL server, you should have no problem integrating withyour DASP database.

 

Awesome! thats great guys.


Im building a clientside application for a service center that


will also providecertain functions the cleint app has but via the web for data capture and reporting(sql Reporting services that is).


So instead of dealing with data contention issues and synching I can pull the data from the same source at DASP and provide a workingmodel and proof of concept to the client.


I hope theperformance will not falter to bad, in the event the client needs more speed they will just have to expose their sql server to the net from the service center to mantain local performance and have the website perform as usual. But thats added hassels for them and I'd rather have some full timetechs at DASP handle it.


Ineed to research a little about DASP policy with data backup protocolsand downtimes that have been occuring due toservicing or what have you.


But for now I'll be signing up with DASP and get my server and website up.


Thanks again for all your help and answers.


Alex.