Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
edmosc
Starting Member
1 Post |
 Posted - 2007-07-31 : 14:55:18
|
| I work extensively with Access; I have a new project with very large tables (as many as 15 million records). Is it worth my while to link Access to SQL Express if both are on the same machine? I've downloaded SQL Express and installed it, but it won't let me link to Access 2003. Is there an update or patch to Access 2003 that will make this work? If I do make the link successfully, will it be transparent - that is, can I work in Access as I always have, or would I have to learn how to create databases and queries in SQL? (I do know that I can make tables in Access and migrate them to SQL Server).Where would I find simple step-by-step instructions to do this - my interest is more in the substance of my data analysis than in programming per se.Ed |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2007-07-31 : 15:28:41
|
| look into access .adp |
 |
|
|
|
|
|
Link to Access