ACCESS FEED: RE: [MS_AccessPros] SQL backend and Access Front end

Jumat, 03 Januari 2014

RE: [MS_AccessPros] SQL backend and Access Front end

Thank You Bill. I am on vacation right now and will try this when I get back to work. I have a Tasks and Projects Database that I would love to try this on.

Sent from Yahoo! Mail for Windows 8

From: Bill Moscawrmosca@comcast.net>
Sent: ‎Thu, ‎Jan‎ ‎2‎, ‎2014 at ‎12‎:‎47‎ ‎PM
To: MS_Access_Professionals@yahoogroups.com>
Subject: RE: [MS_AccessPros] SQL backend and Access Front end

Jim SQL files are not like Access files. If you want to copy the files (both database and log) from computer 1 to computer 2 to these steps:

1. Make a full backup of the database on Computer 1

2. Copy the .bak file to Computer 2

3. Open SQL Server on computer 2 and do a restore using the .bak file as the source.

The SQL wizard is pretty easy, but if you need more detailed instructions let me know. Once you have the SQL database restored you can link to the tables using an ODBC connection.

Regards,
Bill Mosca,
Founder, MS_Access_Professionals
That'll do IT http://thatlldoit.com
MS Access MVP
http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852

My Nothing-to-do-with Access blog

http://wrmosca.wordpress.com

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Jim Wagner
Sent: Wednesday, January 01, 2014 8:49 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] SQL backend and Access Front end

Hello all,

I have a question about front ends and backends.

I tried a couple of months ago this scenario.

I have sql express on my work desktop. I tried to open the sql file on my work laptop and it did not recognize the file in sql express. I was wondering if there was a way to make this file portable so that I can create a front end and keep it on a usb drive to the sql file on the usb drive? I have a personal task database that I would like to learn to use sql as the back end and access as the front end.

Thank You

Jim Wagner

Sent from Yahoo! Mail for Windows 8