Question access and SQL copy into new database

[Joe8915]

I have Access running as the front end and SQL as the back end. What I would like to do is take a copy of DB and do some work off site on the DB. Of course the tables are link to SQL, which makes it impossible to work on. Is there any other way that I can make this work. I don't want to un-link tables.

I was thinking about making new DB and import all the objects.

Any other ideas?

Thanks

 

[boblarson]

Create an Access Backend by importing the table structure into the new backend file. Then you can use the Linked Table Manager to relink to the Access backend and then use it again when you want to go back to the original tables. Just remember though that not everything that works with Access tables works with SQL Server tables. Most things will but just be aware of what you are attempting.

 

[thechazm]

One other way would be use a free opensource program like sqlite or something. Just search on google. And dump the sql tables to a file. If you have sql at home you can use the same program to import the information into your own sql server and continue working. This keeps the same format of everything and allows your frontend to work and test it effectivly with new functions and whatnot.

Done this plenty of times on opensource projects.

TheChazm

 

[Joe8915]

Bob/Chazm

Chazm, thanks for chimming in. Sorry I ddid not back to you guys fast enough. Chazm I don't have a copy of SQL at the house, so I guess that idea is out, but thanks for the input.

Bob, I created a new DB. I could not import due to the other DB is secure. So I thought maybe I could export to the new DB by definition only. But it still exported the data anyway and it was still link to the SQL.

Did I miss something? or any other ideas.

Thanks

 

[thechazm]

You could always use the free version of mysql to load a server on your home computer. Its up to you. As for access I'm not sure what the guts of the file you are needing to import contains but you might be able to tie a datasource connection to a file instead of an active database. Don't know if it will pickup the data the same way but maybe worth a shot.

Also if its delimited inside you still might be able to pull it in.

TheChazm

 

[Joe8915]

Chazm, I am doing it a real ugly way. But it will work. Export to Excel and then Import from new DB. Pain staking job. But I think it will work.

Thanks for all the input

 

[thechazm]

Good luck and at least you got the data

TheChazm