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 |
|
tcarnahan
Starting Member
23 Posts |
 Posted - 2005-09-27 : 16:02:22
|
I have used MS-Access .MDB files and I have used SQL-Server Enterprise manager, but I have limited experience with Access .ADP (Project) files.In my current task, I don't have Enterprise Manager available and I need to build tables on the server vice merely linking to them. QUESTION: Can you CREATE tables on the server from a Project file? If so, how?Thanks ahead of time for your help!  |
|
|
Hyukevain
Yak Posting Veteran
66 Posts |
Posted - 2005-10-07 : 17:15:05
|
| Yes, set connection in your ADP to server, go to Table tab in your Access project, right click and choose new.This only work if your server use MS SQL 7 not 2000. At least it works for me because I use MS Access 2000. |
 |
|
|
|
|
|
ACCESS Project file / SQL