Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
ACCESS Front End MSSQL Backend
How Do I do convert my access database so my tables are on a mssql server. I have the server running on my home machine as a server, and am trying to access it from work. I have no clue how to accopmlish this. I have tried DTS from MSSQL tools, I have tried Upgrade manager from Access tools...- DavisDS
- Thread
- Replies: 13
- Forum: Microsoft: Access Modules (VBA Coding)
-
Access Excel From Access Closing Issues
Ref. Forum: thread692-90756 The above Thread discusses the issues with running Excel Automation from Access. Basically when Excel is opened ANYTHING the user does to alter Excel "like closing it" causes issues with the automation. More specifically, when the user MANUALLY closes Excel, Access...- DavisDS
- Thread
- Replies: 18
- Forum: Microsoft: Access Modules (VBA Coding)
-
Recordset Data issue with dashes
In Reference to thread705-22237 I have a similar problem. I Use a data field containg strings with dashes, A social security number for example. With a Social the solution seems simple: break the string and concat it with the '-'. I also use other numbers with inconsistant...- DavisDS
- Thread
- Replies: 11
- Forum: Microsoft: Access Modules (VBA Coding)
