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 |
|
portrman
Starting Member
24 Posts |
 Posted - 2001-04-18 : 22:02:19
|
| I have sql server 2k running on my computer for development and also MS Access 2k. I am linking to my sql database using the access adp file. In the connection options I have selected a user that I created on my machine and added to my database as an "owner". The problem is that access after it brings in all the tables adds (ado) to the end of every table name. This creates problems with forms and queries in access that are using the table name without the (ado) part at the end of the name. If I use the public account to auth then I don't get the (ado) at the end. What is up with this and how do I correct this behavior. This occurs when using Access 2k or XP and SQL Server 2k or 7.Thanks,Chad Betzportrman<remove>@hotmail.com |
|
|
|
|
|
Access adp files and SQL Server