• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Database / SQL Server question

A

archcommus

Diamond Member
I am working for a software company where I am using Access to access their database (not sure if it's Oracle, or SQL Server, or what). Currently I am working from home via VPN. Because the connection is unrealistically slow to to do real-time calls to the database via Access (can take up to an hour to run a query), I imported all of the tables of their database into a local Access .mdb file and have been using that (came to about 34 MB of text data).

The annoyance with this is that because there is no SQL server to parse my data, flags like "1" are no longer interpreted properly (since it's actually input as "-1" into the table), so all of those must be changed when I make a version for the corporate network, and I cannot simply update the targets of my table links via the Linked Table Manager because they are being converted from local links to ODBC links. So I must delete and re-add every table link I have.

My question is, could I download and install the free SQL Server Express Edition from Microsoft, download all of their database data, and set up my own database locally? Would this allow me to input flags such as "1" and have the server interpret them as "-1" in my tables? Would this allow me to have table links with the little globe icon next to them so that when I make a new version for the corporate network, all I have to do is use the Linked Table Manager to update my links to the real database? I would like to know if this can work this way before I go ahead install .NET Framework 2.0 and SQL Server and all that (remember, I'd be getting the free Express Edition).

Thanks!
 
I believe one limitation of Express edition is that it only allows one client connection at a time (someone correct me if I'm wrong).
 
Originally posted by: rsd
I believe one limitation of Express edition is that it only allows one client connection at a time (someone correct me if I'm wrong).
Click to expand...
That would be fine as I would only be using it locally for myself. I just want to make sure it'll parse flags properly and that the linked tables in Access will show up as ODBC links even though the database is local. This would allow me to use the Linked Table Manager to simply update the links to their database when I put it on the network (when a linked table targets a table in another .mdb file and not a table via ODBC you can only use the Manager to specify a NEW .mdb file, not change it to an ODBC link).
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top