I'm in the process of designing a new vb 6.0 app which will need to connect to a database.
I have the database tables stored on a computer here at the office - that's easy enough for those of here to be able to access.
But I have guys out in the field that also need to have access to those tables.
I'm hoping that I can employ 1 connection string so that no matter where a user is they can access that database.
The storage computer only has the Access tables and is running Win98. Do I need to install SQL Server on that computer in order for the app to access the tables?
I'm not sure if I'm asking the question properly. I've already tried setting up a DSN and like I said - that seems to be fine if only those of us here in the office are using it.
I also have the tables stored in a subfolder on our company website - there are a couple of tables in there that receive data from a couple of forms on the website.
Any help will be most gratefully appreciated!!