Using SQL server as a backend

G

Guest

Hi,

I'm currently experiencing problems with concurrent users on access and have
decided to use SQL server as the backend and then Access as the front end.
Can anyone reccomend any sites where I can gather some info on how to get
started with doing this as I have no experience with SQL server.

Thanks,
Chris
 
G

Guest

Chris,

Don't know whether it is still in publication, but when I made that move, I
found:

"Microsoft Access Developer's Guide to SQL Server", by Mary Chipman & Andy
Baron to be an extremely useful guide.

Having said that, I've got several Access applications in use by as many as
30 concurrent users, that rarely encounter problems. How many users do you
have? Are they all using their individual copies of the application, or are
they using a single copy that is on your network?

Dale
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form datasource from sql server backend 1
SQL Server Backend is Read Only 7
Access and SQLServer Express 2005 3
SQL Server Backend: linked tables or no more bound forms ? 4
max # of concurrent users: access backend versus sqlserver 11
Advantages of using VB.net and Access (backend) 17
MS Excel as backend/database for the website 3
Combo box not displaying field from SQL backend 1

Top