MS Access and FileMaker...

SQL For MS Access?

Please support our MS Access and FileMaker Pro advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jun 2007

Posts: 49

Reputation: Mr.Wobbles is an unknown quantity at this point

Solved Threads: 2

Mr.Wobbles Mr.Wobbles is offline

Offline

Light Poster

SQL For MS Access?

Feb 25th, 2008

I am writing a program in VB 2005 Express and I am using SQL to insert, delete, etc. I was curious if there was a SQL statement that would allow me to backup the database in Access - I have tried the MySQL syntax for it, but I can't seem to figure out what Access would use. The regular SQL statement throws an error.

Mr.Wobbles~

•

Join Date: Feb 2007

Posts: 2,068

Reputation: debasisdas will become famous soon enough

Solved Threads: 123

debasisdas debasisdas is offline

Offline

Postaholic

Re: SQL For MS Access?

Feb 26th, 2008

You can try to make a copy of the original MDB file and that can be used as a backup of actual data. The syntaxes of oracle or mysql will not work here.

Share your Knowledge.

•

Join Date: Jun 2007

Posts: 49

Reputation: Mr.Wobbles is an unknown quantity at this point

Solved Threads: 2

Mr.Wobbles Mr.Wobbles is offline

Offline

Light Poster

Re: SQL For MS Access?

Feb 26th, 2008

I have tried that before but this is my problem with that:

http://www.daniweb.com/forums/thread99598.html

So I was looking to see if there was another way -- I have had this problem for a long time...

Mr.Wobbles~