Linking Alpha 4 database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Alpha 4 database (.dbf) I need to read with Access 2003. I can
open it easily as a linked database (Access does it automatically) by double
clicking on it.

I need to be able to do this automatically to read data from the Alpha
dbase. I can't seem to get an OLE or ODBC connection to work. Has anyone
been able to do this? What connection string could I use? How can I see
what string Access uses when it links to the Alpha databse?

Thanks
 
Go to Tools/Options/General and unhide the system objects.
Open the MSysObjects table and look for your linked Alpha 4 table. You
should be able to see the actual connection string in the connection column.
 
Open the table in Design View, ignoring any warnings. Right-click on the
titlebar and choose Properties. The connection string will be the first
property. (Description)
 
Arvin Meyer said:
Open the table in Design View, ignoring any warnings. Right-click on the
titlebar and choose Properties. The connection string will be the first
property. (Description)
Click to expand...

I'll be darned. I never knew that. Although I had to right click on
a field and then choose properties.

Now this is two things I've learned about Access in 2007.

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
 
How funny I should find this post! I'm working on a way to upload from
Access '03 to Alpha 5. Anybody know what file formats Alpha 5 understands?
Any tricks or pitfalls?
--
Why are you asking me? I dont know what Im doing!

Jaybird
 
Tony

you never knew how to get a connection string?


ROFL

you know-- in Access Data Projects you don't need to deal with ANY of that
crap
 
Back
Top