Help, urgent, connection to access database

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

Hi, all
I met a problem about access database connection.
I have a program reading data from access database through ODBC.
When the access database located on local server, and created ODBC
linked to local database,the program runs without problem, but if it is a
network shared database, and created ODBC linked to the shared database, the
program prompts error: "workgroup file is missing".
Yes, I used workgroup file in current database and set correct security.
So what's the problem? is problem of the ODBC drive?
 
you should not be using ODBC

Access stopped working with ODBC back in 2000 release--- everything
internally is OLE DB

you shoudl go to SQL Server and use Access Data Project

it's a lot lot simpler
 
you should not be using ODBC

Access stopped working with ODBC back in 2000 release--- everything
internally is OLE DB

you shoudl go to SQL Server and use Access Data Project

it's a lot lot simpler
Click to expand...


Note that this person is really A a r o n K e m p f and that he is not an employee
of Microsoft.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
note that tony is neither

MOST
VALUABLE
or a
PROFESSIONAL


anyone with a clue would have started using SQL Server a decade ago;
it is a completely superior platform in all regards-- with no
negatives

only a retard that can't learn a real database would ever use Access
MDB
I mean get real-- move to ADP or real VB-- either way, Access MDB is
dead and it has been for a decade
 
Back
Top