Database on Server, how can I access it?

[memevertical2]

Hi everyone. I made an app that uses a MDB (access) database. But now, my boss wants to have that same app on our second office (which is on a different location), and be able to access the same database. He wants both offices reading and writing to that database.

How can I do this? Can I just place the .mdb on a server and have both apps pointing at it?

Sorry for the dumb question but I have never done this.

By the way, I'm using ADOconnection to pint at the DB, and ADOTable and ADOQuery for everything else. All SQL commands.

Thanks.

 

[JES1904]

IF the file is visible from each location through your server, it should be accessible from each. The connection string may differ between locations depending upon how it is defined for access at other locations. Your network manager should be able to give you specific requirements to alter the connection string address.

 

[memevertical2]

Oh, you mean like if it was shared on a local network?

Thanks.

 

[Opieo]

Or even a mapped network drive works nicely.
If you need to, you can use the server name though "\\srvrMain\subfolder\myDBFolder".
Either way it is still the [blue]Data Source=[/blue] section of your connection string.
The simple answer to your question

Can I just place the .mdb on a server and have both apps pointing at it?

is Yes, you can.

~
“Your request is not unlike your lower intestine: stinky, and loaded with danger.” — Ace Ventura.

 

[whosrdaddy]

please be aware that ms access has issues when the database grows too large, the chance for corruption is big when having multiple concurrent users. Try moving to a real database server like ms sql or mysql, chances are big you don't have to change anything in your application...

my 2 ç...

/Daddy

-----------------------------------------------------
What You See Is What You Get
Never underestimate tha powah of tha google!

 

[JES1904]

Yes, If you can see the file on your station, you should be able to work with it. So should others if you allow sharing on the file. There are a number of web sites that might have info that would be helpful.Delphi.about.com, Delphi3000.com, or this site. It depends on what you need specifically.

 

[MagicFrisbee]

What whosrdaddy is saying that MS Access databases have a limit of 2 GB and that counts deleted records and stuff like that. You'll definitely want a backup strategy. But MS Access wasn't entirely written to support multiple read-writes at a time. You really should scale soon to a real DBMS because if you're boss is enthusiastic enough, he'll have you writing a web interface in a few years and want it accessible through web services on hand-helds, etc.

GIS Programmer
City of Orem, UT

http://gis.orem.org