Link access table via odbc driver

Question

0.00/5 (No votes)

See more:

I need to link to a file which is in Access format (it can be opened by Access), but it has another file type - .dvprj instead of .mdb or .accdb. The file name needs to stay .dvprj so it will open in its application.

Access will only recognize .mdb or .accdb databases when linking to Access External Data > New Data Source > From Database > Access.

What I have tried:

I set up an ODBC Data source with a User DSN and as a File DSN, but when I try to link a table from Access using External Data > New Data Source > Other Sources > ODBC Database, using either method, I get the following error message:

"You cannot use ODBC to import from, export to, or link an external Microsoft Jet or ISAM database table to your database. (Error 3423)"

Any ideas?

Posted 6-Feb-18 11:00am

Member 13664630

Updated 2-Mar-18 6:30am

Add a Solution

Comments

Maciej Los 6-Feb-18 17:18pm

I'm not sure it's possible to link DeJaVu file to MS Access database. I can not find any specification for that file.
DeJaVu X3 Professional - Manual[^]

RedDk 6-Feb-18 18:46pm

Hmmm, so it does ... (Access opens .dvprj) ... but not without a note from the OS. Could you make a copy of the dvprj and change the extension to .mdb and continue from there?

Maciej Los 7-Feb-18 17:07pm

Well... I have no chance to check it out, because i don't have DeJaVu software. I'm pretty interested if your suggestion may help to resolve OP's issue.

RedDk 7-Feb-18 17:22pm

Oh Yeah ... non-attending OP in the crosshairs ...

MJ, ever vigilant, as usual... (all eye did was rename the .mdb with the extension .dvprj)

Member 13664630 2-Mar-18 12:33pm

Sorry! New to the forum and only got notification of the solution recently (15 Feb Message - plus recovery from email backlog). I'm back on the path of e-mail checking righteousness now. Thanks for the help!

Maciej Los 11-Feb-18 9:10am

Can you share sample file?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Gustav Brock · Answer 1 · 2018-02-14T23:11:00

First link a copy of the file, renamed as accdb (or mdb).

Then run code to relink to the table(s) from the original file:

visual

Public Function Relink()

    Dim Database    As DAO.Database
    Dim Table       As DAO.TableDef
    
    Dim Connect     As String
    
    Set Database = CurrentDb
    Set Table = Database.TableDefs("SomeTable")
    
    Connect = Table.Connect
    Debug.Print Connect
    Connect = Replace(Connect, ".accdb", ".dvprj")
    Debug.Print Connect
    
    Table.Connect = Connect
    Table.RefreshLink
    Debug.Print Table.Connect

End Function

Member 13664630 · Answer 2 · 2018-03-02T06:30:00

Solution 2

This is a great solution.

I will give it a try as I move forward.

Thanks, Tom

Posted 2-Mar-18 6:30am