VB6 with MS ACCESS 2007

Question

1.00/5 (2 votes)

See more:

I created an application using VB6 and Ms Access(Back End) it works fine using Desktop PC. If i'm going to put the database in a server do i have to change any of my codes(connection string, etc.). Can i install MS Office to a server computer? Please help. thanks

Posted 14-Aug-13 12:09pm

ProgrammingEnthusiast

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ron Beyer · Answer 1 · 2013-08-14T12:16:00

You don't need to install Office to access an mdb or accdb file, all you need are the proper ODBC drivers available on the server. You will need to change your connection string to connect to the proper place on the server, it really depends on how you access the server.

Are you installing it to a server on a local LAN with network credentials? Are you wanting to upload it to a website and access it there? Need to get more information about your intended usage before we can say how to change the connection string and if your method of connecting will work. Please post your connection string and relevant code section for connecting to the DB (removing any passwords of course).

Dave Kreskowiak · Answer 2 · 2013-08-14T15:58:00

First, Access is a DESKTOP, file-based, database, not really designed for multiuser access. In order for your clients to use an Access database, the database file would have to be on file share on a server that everyone who uses the database has both read and WRITE access to. This poses security problems.

Yes, you would have to modify the connection string to point it at the location of the database file.

Scrap this and switch to SQL Server or some other real database engine that works over TCP/IP.

VB6 with MS ACCESS 2007

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

VB6 with MS ACCESS 2007

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us