473,385 Members | 1,922 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

dbOpenSnapshot

ANyone know what effect dbOpenSnapshot has when used in the following
example?

myQuery.OpenRecordset(dbOpenSnapshot)

Mar 22 '07 #1
2 17410
Hi,
ANyone know what effect dbOpenSnapshot has when used in the following
example?

myQuery.OpenRecordset(dbOpenSnapshot)
Among other things you cannot modify the data in a Snapshop - read more
about it here :

http://www.cesis.lv/learn/access/aba15fi.htm#I29

Regards
Jens
Mar 22 '07 #2
thanks Jens

On 22 Mar, 10:17, "Jens Schilling"
<jensschillingBitteLoesc...@fissership.dewrote:
Hi,
ANyone know what effect dbOpenSnapshot has when used in the following
example?
myQuery.OpenRecordset(dbOpenSnapshot)

Among other things you cannot modify the data in a Snapshop - read more
about it here :

http://www.cesis.lv/learn/access/aba15fi.htm#I29

Regards
Jens

Mar 22 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Lauren Quantrell | last post by:
In my Access2000 .MDB database I use this sort of structure all over the place (How do I replace it in my Access2000 .ADP database?): Dim db as Database Dim rs as DAO.Recordset Dim strSQL as...
4
by: nick_faye | last post by:
hi guys, hope somebody can assist me. i have two ms access database. i have to copy the entries in database1 to my database2. however, i have to copy entries from database1 that does not...
11
by: Mr. Smith | last post by:
Hello all, My code can successfully open, write to, format and save several worksheets in a workbook then save it by a given name, close and quit excel. My problem is that if I try and do it...
5
by: Dean | last post by:
Has anyone toiled with creating/using alternate domain aggregate functions? I have been messing with that a little. The one recordsource I have been working indicates I get 20 to 40% savings in...
18
by: WilhelmAccess | last post by:
Hi, I am trying to automate the running of a SQL Query. I have a Table in Access 2003 that contains records with several fields, (member identifier, $ amount and months during the year they were...
2
by: LostDeveloper via AccessMonster.com | last post by:
Relationship goes Certification can have multiple variations (any single variation satifies the certification), which require multiple course groups which require any one of the products assigned...
1
by: redbenn | last post by:
I have an interesting situation. In one table (we'll call it Tabel1) I have requests. Each request can contain multiple codes In the other table (Tabel2) I have a bunch of results, with unique...
5
by: The Pipe | last post by:
Hello I have a table that I need to export to a .asc file format. I have had several attempts at getting this to work but with no luck. Basically the file would need to have every record...
9
by: EVH316 | last post by:
When I call this function Access gives me error msg "Too few parameters. Expected 3. " on the Set rstDAO = qryDef.OpenRecordset. Then I changed to Set rstDAO = qryDef.OpenRecordset(dbOpenSnapshot,...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.