Updating current dbase

[berger01]

I have developed a 2010 access Database that is successfully being used in all 50 States for the last 3 years. It’s time to improve the database and add features. I have some general questions before I start.

Each database resides locally on each Offices server. The databases are split and multiple users in each office use the application. Once distributed, I (Developer) will not have any access to the BE. The improved database will be distributed and then split once again. I plan on writing code to import all tables form the old to the new.

· Importing data from old dbase to new should be easy, but I'm concerned about how to bring attachments over to the new. Any thoughts would be helpful?
· Any thoughts on possibly upsizing to an SQL Server? Each office is equipped with SQL.


Thanks in advance for any comments.

 

[billmeye]

Instead of creating a new environment, you can progamatically add tables, fields etc. to the backend DB's. What is motivating you to start over?

Check out this link:

http://aislebyaisle.com/access/vba_backend_code.htm

 

[berger01]

Not really starting over. I have the original dbase. I just need to update/improve like adding some new queries, reports etc. In the new I will provide the import code for populating the new tables with the old data. I don't have access to the BE's. So I just have to distribute an updated version.

Thanks

 

[billmeye]

The reason I asked is if your not making any changes to the tables then you should only need to give your users your new front end and not worry about importing data. You just need to have the users relink to their BE location either with the Linked table manager or with VBA code you include.

 

[berger01]

Unfortunately I do need to add some new tables and fields to existing tables. Evan if I had access to the BE's, having 50 BE's in differenct locations would also be heavy lift for updating each individually.

So I'm thinking publishing an updated version and importing old data is what I'm stuck with.

Thanks

 

[billmeye]

Well, take a look at the link I provided. Using VBA you can easily add tables, fields etc. to BE databases and not worry about the actual data in the tables. You can do this with a separate update DB before the users begin using your new FE.

 

[berger01]

I sure will, thanks for the information