Tags Tags

linking to SQL Server db table

May 15th, 2012 - 08:30 am ET by colmkav | Report spam
Help Create a new topic
Hi,

I may need to convert data stored in an Access database to a SQL
server db due to space issues.

Can you pls tell me whether I can simply link to the SQL Server table
through linked tables and use all the same queries that work on my
Access tables? What issues do I need to resolve if any?

thx
Colm
email Follow the discussionReplies 6 repliesReplies Make a reply

Replies

#1 Ron Weiner
May 15th, 2012 - 08:23 pm ET | Report spam
colmkav formulated the question :
Hi,

I may need to convert data stored in an Access database to a SQL
server db due to space issues.

Can you pls tell me whether I can simply link to the SQL Server table
through linked tables and use all the same queries that work on my
Access tables? What issues do I need to resolve if any?

thx
Colm



The simple answer is "Yes You Can". However there are many security
and performance gains that you might avail yourself of as you gain
experience with Sql. I suspect you will be pleasantly surprised at how
easy this change is.

Rdub

Similar topics

Make your own search :