Connect Access database to a server

[Lucas83]

Hi Everyone,

Well first of all, I would like to thank you all, these forums are great, very helpful, and I'm very glad to see so many helpful people in here hehe. Well, after this little introduction, I have a question about Access, would it be possible to connect an Access database to a server? What I look for is a way to update data in some tables in my Access database anytime the server would have new data in it. would I need to learn Visual basic? or is the any other way? I can try visual basic, but I don't have so much time, so I would like to know what options exist to connect a database to a server. Thanks in advance!!

Lucas

 

[HiTechCoach]

Which"server" are you wanting to connect to?

If you are referring to an SQL Server, if you have the ODBC driver's istalled, you might be able to link to the tables if you have permissions to the database.

 

[Chaz]

Simplest way (and assuming this is what you are looking for) is as follows:

1. Frontend database either on your user's machine or a network location.
2. Backend of the database on an accessible share somewhere on your network.

The front and backend are 'connected' by a linked table (manager) and is fairly easy to manage.

I have around 10 users of my database, each have a unique copy of the front end (I dont share the front end - had too many issues) and each of their frontends point to a common backend.

The 'each' frontend is a bit of a pain, especially when I need to make changes but its the only way I could get away from 'Admin locked' and other locked errors.

 

[Lucas83]

Thanks both of you for your replies!!. Sorry, I should explain the issue about the server. I would like to connect a database to a nasa server to get new EVI values (Enhanced vegetation index). EVI values are released every two weeks, so the database should be able to get the new values every two weeks. Thus, the database would be updated every two weeks. Do you think would be possible? Thanks!!

 

[HiTechCoach]

The 'each' frontend is a bit of a pain, especially when I need to make changes but its the only way I could get away from 'Admin locked' and other locked errors.

Chaz,

Why is it a pain?

Are you using any type of front end auto updater?

 

[HiTechCoach]

Thanks both of you for your replies!!. Sorry, I should explain the issue about the server. I would like to connect a database to a nasa server to get new EVI values (Enhanced vegetation index). EVI values are released every two weeks, so the database should be able to get the new values every two weeks. Thus, the database would be updated every two weeks. Do you think would be possible? Thanks!!

It may be possible. It all depend on if the other "server" is configured to allow it.

Does the other "server" actually allow this?

Do you know what RDBMS the other "server" is running?

It may be easier to see if they provide exports (dumps) of the data

 

[Chaz]

Chaz,

Why is it a pain?

Are you using any type of front end auto updater?

Theres such a thing? Lol - just never bothered to look. Could probably just write a batch file but too lazy.

 

[SOS]

Theres such a thing? Lol - just never bothered to look. Could probably just write a batch file but too lazy.

Yeah, Bob Larson has one here and Tony Toews has one here.

 

[Chaz]

Yeah, Bob Larson has one here and Tony Toews has one here.

Thank you kindly.