Help, urgent, connection to access database

[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?

 

[Todos Menos [MSFT]]

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

 

[Tony Toews [MVP]]

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

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/

 

[Todos Menos [MSFT]]

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