Can anyone recommend a decent program for editing Access .mdb database. My old system has Access on it, but not my new one, I need to be able to edit my databases without having to go back and forth between two computers.
Any suggestions? (prefereably something with a trial edition, or better yet, free)
Thanks
Connecting to Microsoft Access - OpenOffice.org Wiki
JET, it sucks and blows at the same time.
throw new ArgumentException (String, String, Exception)
Whenever I try that it just opens my database and converts it to its own .odb format, granted I can then access it and edit it, but its not much good if it doesnt edit the original database.Originally Posted by TheAnimus
Am I doing something wrong here?
I think Access supports ODBC (or something of that ilk) doesn't it?
...which means you can access it with real old fashion SQL statements from code?
...which might mean you could also connect to it from SQL Server Management Studio?
..which might mean you can connect to it from SQL Server Management Studio Express which is free
sql server express - Google Search
(and if none of that works, at least you'll have SQL Server express, which may encourage the powers that be to throw the access DB into a deep hole where it belongs)
They told me I was gullible ... and I believed them.
there is a JET (the techonology behind the peice of crap that is access, which is still market leading for what it is note) ODBC driver.
Problem is i think you will lack a front end thats not Access, it really is the best in the class if you require those features.
Another option might be programming an interface yourself, if its a simple task you need to do, its really easy to write something with C# Express (free).
What is it you need to do? Why do you need the access from a second machine (note there can be concurancy issues).
throw new ArgumentException (String, String, Exception)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Reply With Quote